list totals for various sheets

T

Tony H

I have several worksheets (could be 2, could be 20) and I want to list the
totals into one final sheet
 
P

Pete_UK

List your sheet names in one column (eg column A), then in B1 use this
formula:

=INDIRECT("'"&A1&"'!H13")

This assumes your total is in cell H13 on each sheet - adjust to suit,
then copy down.

Hope this helps.

Pete
 
T

Tony H

Many thanks. Works a treat.

Tony H


Pete_UK said:
List your sheet names in one column (eg column A), then in B1 use this
formula:

=INDIRECT("'"&A1&"'!H13")

This assumes your total is in cell H13 on each sheet - adjust to suit,
then copy down.

Hope this helps.

Pete
Click to expand...
 
Top