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/

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?