Worksheet Formula
I'm not sure if this is what you mean but if you type =sum( and the shift
click the last sheet and then the cell you want to sum e.g. C8 andclose ) it
will sum C8 for all of the pages.
-John
"Kelly" wrote:
I have a workbook with 100 worksheets. I need to have the data that populates
lets say field C8 in all 100 worksheets in my Log Sheet. How can I copy this
down the rows in my log sheet and have the formula change to each sheet.
An example would be:
=+001!C8
=+002!C8
=+003!C8
Thanks
Kelly
|