| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a worksheet from one file to another
I have 5 identical Excel workbooks.
I created a worksheet on one of the files, which consists totally of references to various cells in the existing sheets. I want to copy this sheet to the other 4 Excel workbooks, however the references point to the original file and its cells, not the one I am adding it to. How is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a worksheet from one file to another
Its really trying to be helpful...
To fix it: Copy it to one of the other workbooks, with the new sheet the active sheet, click Edit - Replace. In the Find box, type [old workbook name] - the way it appears in the cell references and leave the replace box empty. Click Replace All and they should now work the way you wanted... " wrote: I have 5 identical Excel workbooks. I created a worksheet on one of the files, which consists totally of references to various cells in the existing sheets. I want to copy this sheet to the other 4 Excel workbooks, however the references point to the original file and its cells, not the one I am adding it to. How is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet from one file to another | Excel Discussion (Misc queries) | |||
| Automatically copy the file name to the worksheet tab | Excel Discussion (Misc queries) | |||
| copy worksheet without reference to old .xls file | Excel Discussion (Misc queries) | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| How do I copy a worksheet from a workbook as csv file | Excel Discussion (Misc queries) | |||
Linear Mode
