| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.officedev
|
|||
|
|||
How to copy workbook?
Can I copy several sheets at once, from one workbook to another, using
Worksheets.Copy? In this case, will the references to the formulas that are in the copied group of sheets maintained correctly? "macropod" wrote in message ... Hi LF, I am not sure I understand. When you copy over from one worksheet to another, don't you simply copy the formulas? If you have a formula on Sheet1 that refers to Sheet2, for example, the copied formula will point to Sheet2 in the original workbook, not Sheet2 in the copy. Cheers -- macropod [MVP - Microsoft Word] |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy pivot table and source from workbook 1 to 2. | Excel Discussion (Misc queries) | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Threaded Mode
