View Single Post
  #1   Report Post  
Old August 22nd 09, 12:19 AM posted to microsoft.public.excel.worksheet.functions
marquisv2001 marquisv2001 is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 1
Default How can I change the formula for multiple cells at once?

I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but they
make calculations based on the workbook they came from rather than the new one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?