Worksheet with most rows
 

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.

Worksheet with most rows
 

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"))

--
Biff
Microsoft Excel MVP


"Jack Deuce" wrote in message
...
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.

Worksheet with most rows
 

Thanks so much. Worked perfectly.

On Sat, 21 Mar 2009 14:04:33 -0400, "T. Valko"
wrote:

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"))

Worksheet with most rows
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jack Deuce" wrote in message
...
Thanks so much. Worked perfectly.

On Sat, 21 Mar 2009 14:04:33 -0400, "T. Valko"
wrote:

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"))