equation change

[Darius]

I have 5 sheets in a workbook and have 100 workbook like this. In each
worksheet I have about 10 equations which use data F3:F200 in sheet1 and
F3:F230 in sheet2 etc. Lets consider equations like =Average(f3:f200), =
Var(F3:F200), etc.

Now how can I change F3 to F93 for each of this equation in either one sheet
or the whole workbook?

Thanks for your help

 

[Sean Timmons]

Well, since I'm not sure of your other equations, I can only assume, but you
should be able to use Ctrl+H (Find and replace) and change (F3: to (F93:
using replace all

 

[Darius]

Yes I cand do that but I want the rest of data beneath it also change, so if
F3 becomes F93 then F4 becomes F94... F200 becomes F293. How about this?

 

[Sean Timmons]

once you change the first one, you can just drag the formula down and replace
the remaining ones....