| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy a worksheet from one workbook to another
I need to copy a worksheet from one workbook to another similar one with the
same worksheets, and I have a formula inside this worksheet that references to cells in other worksheets of the workbook; So I need that the formula points the same cells of the new workbook. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy a worksheet from one workbook to another
You can do this Joe
Select all cells Edit Replace Replace = With @@@@ Or something else that is unique Then copy the sheet and replace @@@@ with = -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Joe" wrote in message ... I need to copy a worksheet from one workbook to another similar one with the same worksheets, and I have a formula inside this worksheet that references to cells in other worksheets of the workbook; So I need that the formula points the same cells of the new workbook. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy a worksheet from one workbook to another
Oops
Use $$$$ @@@@ is not working -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... You can do this Joe Select all cells Edit Replace Replace = With @@@@ Or something else that is unique Then copy the sheet and replace @@@@ with = -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Joe" wrote in message ... I need to copy a worksheet from one workbook to another similar one with the same worksheets, and I have a formula inside this worksheet that references to cells in other worksheets of the workbook; So I need that the formula points the same cells of the new workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheet from one Workbook to another Workbook | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| copy worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Can not copy a worksheet to another workbook | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
