equation change

  • Thread starter Thread starter Darius
  • Start date Start date
D

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
 
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
 
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?
 
once you change the first one, you can just drag the formula down and replace
the remaining ones....
 
Back
Top