Thread
:
How can I change the formula for multiple cells at once?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How can I change the formula for multiple cells at once?
editlinkschange source
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"marquisv2001" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett