equation change
 

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

equation change
 

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" wrote:

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

equation change
 

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" wrote:

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" wrote:

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

equation change
 

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

"Darius" wrote:

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" wrote:

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" wrote:

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