Summation

  • Thread starter Thread starter kellonjames
  • Start date Start date
K

kellonjames

Hello All,
I have a work book with 200 sheets. each sheet is format exactly the
same way except for the first sheet (the summary sheet). I want to
copy the grand total on each sheet to the summary sheet in the
following format.

sheet # sheet # total
sheet 1 sheet 1 total
sheet 2 sheet 2 total
. .
. .
sheet n sheet n total
 
Say the cell containing the total for each sheet is in A25.

Your list of sheet names is in Column A of the summary sheet, starting in
A2.

Try this formula in B2:

=INDIRECT("'"&A2&"'!A25")

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hello All,
I have a work book with 200 sheets. each sheet is format exactly the
same way except for the first sheet (the summary sheet). I want to
copy the grand total on each sheet to the summary sheet in the
following format.

sheet # sheet # total
sheet 1 sheet 1 total
sheet 2 sheet 2 total
. .
. .
sheet n sheet n total
 
Back
Top