Copying formula...

[Losguapos1]

So i have one workbook with multiple pages and i want to copy formulas from WB1 to WB2 which has the same sheets in it but with different data and overtime i copy a formula it automatically references WB1. Is there any way to copy the formulas and have them reference the sheet in WB2?

Hope this is clear.

Thanks

Los

[TMS]

Press F2 to Edit the cell with the formula. Select the formula in the formula bar and copy it. Select the second workbook, select the relevant cell and paste the formula. Now copy it down if necessary.

[Amanda Wilso]

1. Select the formula cells you will copy, and click Home > Find & Select > Replace, or press shortcuts CTRL+H to open the Find & Select dialog box.
2. Click Replace button, in the Find what box input “=”, and in the Replace with box input “#” or any other signs that different with your formulas, and click the Replace All button.
Basically, this will stop the references from being references. For example, “=A1*B1” becomes “#A1*B1”, and you can move it around without excel automatically changing its cell references in current worksheet.
3. And now all “=” in selected formulas are replaced with “#”. And a dialog box comes out and shows how many replacements have been made. Please close it.
4. Copy and paste the formulas to the location that you want of the current worksheet.
5. Select the both changed ranges, and then reverse the step 2. Click Home> Find & Select >Replace… or press shortcuts CTRL+H, but this time enter “#” in the Find what box, and “=” in the Replace with box, and click Replace All. Then the formulas have been copied and pasted into another location without changing the cell references

[Amanda Wilso]

1. Select the formula cells you will copy, and click Home > Find & Select > Replace, or press shortcuts CTRL+H to open the Find & Select dialog box.
2. Click Replace button, in the Find what box input “=”, and in the Replace with box input “#” or any other signs that different with your formulas, and click the Replace All button.
Basically, this will stop the references from being references. For example, “=A1*B1” becomes “#A1*B1”, and you can move it around without excel automatically changing its cell references in current worksheet.
3. And now all “=” in selected formulas are replaced with “#”. And a dialog box comes out and shows how many replacements have been made. Please close it.
4. Copy and paste the formulas to the location that you want of the current worksheet.
5. Select the both changed ranges, and then reverse the step 2. Click Home> Find & Select >Replace… or press shortcuts CTRL+H, but this time enter “#” in the Find what box, and “=” in the Replace with box, and click Replace All. Then the formulas have been copied and pasted into another location without changing the cell references