How can I change the formula for multiple cells at once?

M

marquisv2001

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?
 
S

Squeaky

Another way is to go to Home>Find and Select>Replace...

Where you find the reference to the old spreadsheet between the [] brackets,
place all of that (including the [] brackets) into the FIND WHAT box, in the
REPLACE WITH box, place the new target. Select Replace All.

Squeaky
 

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

using the =page! feature to transpose a row to column 0
calculation taking too long 7
How can I copy multiple formulas between workbooks at once? 1
Use Formula from another worksheet 3
How to get range names to Apply across multiple tabs 1
Changing Cell References To a Different Worksheet in the Same Cell 3
Revise multiple formula references at once? 6
Hiding Errors for formulas 3

Top