| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need Equation | Excel Discussion (Misc queries) | |||
| Equation | Excel Discussion (Misc queries) | |||
| if equation | Excel Worksheet Functions | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| How do I peg 4 col in an equation so when i add one col it only l. | Excel Worksheet Functions | |||
Linear Mode
