| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying worksheets to a new workbook without formulae referencing original workbook
I have a workbook I need to copy multiple worksheets from into a data
file with one existing worksheet. The copied worksheets contain formulae referencing sheet one from the original so when they are in the new workbook they reference sheet one of the original workbook instead of sheet one of the new workbook like i want them to. Any ideas on how to keep it from referencing the original? Sheets(Array("Dot 1", "Dot 2", "Dot 3", "Dot 4", "Dot 5")).Copy Befo=Workbooks _ ("filename.dat").Sheets(2) Original: ='Raw Data'!F29 New: ='[TVS-Wafer-Master.xls]Raw Data'!F29 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying to a new workbook without formulas referencing original wk | Excel Discussion (Misc queries) | |||
| Excel not copying formula reference to original workbook | Excel Worksheet Functions | |||
| Copying Spreadsheets without referencing other workbook. | Excel Worksheet Functions | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Copying a chart and unlinking it from the original workbook | Charts and Charting in Excel | |||
Threaded Mode
