Worksheet with most rows

[Jack Deuce]

I have a workbook containing 100+ sheets. Is it possible to find
which sheet has the most rows? The data columns in these sheets
contain dates, coin grades and prices.

I have created an Sheet Index (using ASAP) and would like to add the
number of rows each sheet has to the appropriate cell in the Sheet
Index. Is this possible?

Thanks.

 

[T. Valko]

If each sheet is setup to where column A is the first column that contains
data and that column contains the most rows of data.

Assume you have your sheet names listed on a summary sheet in the range
A1:A100.

Try this in B1 and copy down as needed:

=COUNTA(INDIRECT("'"&A1&"'!A:A"))

 

[Jack Deuce]

Thanks so much. Worked perfectly.

 

[T. Valko]

You're welcome. Thanks for the feedback!