Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying to a new workbook without formulas referencing original wk
I have a workbook that contains four weeks of rolling data. Each week I
have to copy the previous 3 weeks in to a new workbook. When I do this the formulas in the new workbook all reference the old workbook. I am using excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying to a new workbook without formulas referencing original wk
The easiest way I have seen to do what you want is to modify all the
formulas before you copy so that you aren't copying formulas. Do this. Select the whole range that you want to copy. Do Edit - Replace - Enter an equal sign (=) for what you want to replace - Enter $$$$$ for what you want to replace the equal signs with. Hit OK. Do your copy and paste. In your destination sheet, select the whole range that you just pasted, and replace all the $$$$$ with equal signs. Done. HTH Otto "joesw" wrote in message ... I have a workbook that contains four weeks of rolling data. Each week I have to copy the previous 3 weeks in to a new workbook. When I do this the formulas in the new workbook all reference the old workbook. I am using excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas between sheets and keeping original ref | Excel Worksheet Functions | |||
Excel not copying formula reference to original workbook | Excel Worksheet Functions | |||
Setting original Formulas for copying | Excel Discussion (Misc queries) | |||
Copying a chart and unlinking it from the original workbook | Charts and Charting in Excel | |||
Copying formulas (relative) give always original value | Excel Worksheet Functions |