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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible Indirect query 1
Continue equation 1
I want the autofill/drag function to skip empty cells 1
Run VBA sort when I open worksheet 2
I need Equation 1
Correction 2
Indirect and sumif functions with multiple workbooks 1
Formula for worksheet that's tallying and pricing 5

Back
Top