| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy / paste
Hi all,
not sure if this is a programming question or not but... i copied (manually) a large range of data from one workbook to another (old version of the book to the new version) some of the cells had formulas that referenced another page in the old workbook. that page was also copied (manually again) now the formulas point to the other workbook. is there any (easy) way to remove the reference to the old workbook and just leave the formulas ie OLD WORKBOOK =Sheet1!$C$2 after copy - NEW WORKBOOK ='Z:\Storage\[Book1.xls]Sheet1'!$C$2 tia J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
![Gixxer_J_97[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
