copying formulas

L

Ladkins

This is probably a simple question for most of you, but I have an exce
file that contains approx. 400 sheets, with a summary sheet. How do
copy a simple formula to read Cell B1, but the next sheet needs to rea
Cell B2 and so on. Example: Sheet #1 is the summary, then sheets 2-40
have a title taken from the summary, so if I do a typical copy formula
it keeps reading Cell B1. Hope my question is clear!!! Thanks
 
A

Alex

If you select ALL of the tabs tha tyou want to add this to, just add it
to the cell for the current displayed sheet. This will modify this
cell on ALL the sheets that are selected.

Hope this helps!

Alex.
 
Top