If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying from one workbook to another, without taking the name of the 1st workbook with it.
Hi!
If you are copying a whole sheet from one workbook to another, use the copy sheet dialogue box. (EditMove or copy sheet..) Remember to check Create a copy and select the workbook to copy to from the upper dropdown box. Alf --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Copying from one workbook to another, without taking the name of the 1st workbook with it.
Hi Jenny
You can do this Select all cells Use replace "=" to " =" (see the space before =) Without quotes Copy the sheet And in the new workbook Use replace " =" to "=" Without quotes -- Regards Ron de Bruin http://www.rondebruin.nl "Jenny S" wrote in message om... I am trying to copy from one workbook to another and when I paste the copied sheet into the new workbook, the cells refer to the name of the first workbook and I want to take that out before I paste into the new workbook. Anyone know how to get around this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula copying from one workbook to another... | MarksNWO | General Discussion | 1 | July 13th, 2004 11:39 PM |
Workbook is taking 2 - 3 minutes to save. Please help | Aaron | General Discussion | 0 | June 23rd, 2004 11:51 PM |
Copying macro with workbook. | Bernie Deitrick | Worksheet Functions | 1 | March 31st, 2004 07:31 PM |
Copying a sheet from one workbook to another creates a link | Centurion | Worksheet Functions | 1 | December 5th, 2003 01:33 AM |
Formula references when copying a workbook | Charlie | Worksheet Functions | 0 | November 5th, 2003 01:41 PM |