Thread: equation change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darius Darius is offline
external usenet poster
 
Posts: 41
Default 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