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!
================================================== ===

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

Hi,

Did you named the 200 sheets?

Thanks,
--
Farhad Hodjat


" wrote:

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