Copying from one workbook to another, without taking the name of the 1st workbook with it.

J

Jenny S

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?
 
A

AlfD

Hi!

If you are copying a whole sheet from one workbook to another, use th
copy sheet dialogue box. (Edit>Move or copy sheet..)

Remember to check Create a copy and select the workbook to copy to fro
the upper dropdown box.

Al
 
R

Ron de Bruin

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
 
Top