Copy and Paste

[Ptrif]

I have 2 identical spreadsheets, I would like to copy one of the sheets from one to the other but when I do that all of the formulas reference the spreadsheet that it was copied from....is there a way to copy a complete tab over to another spreadsheet without the formulas referencing the original spreadsheet it came from? I hope this made sense....any help is appreciated.

Thanks

Paul

 

[SkipVought]

Paul,

1) Select all cells on the source sheet.

2) Select A1 on the target sheet.

3) Edit/Paste Special - Values

will copy/paste VALUES and not formulas.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Ptrif]

Thanks Skip, however I need to keep the formulas, the 2 spreadsheets are identical. I have found a work around by doing a find and replace and just replacing the name of the other spreadsheet to a blank.....was now just wondering if there is another way to do it.

Thanks!

Paul

 

[SkipVought]

Don't think so.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[tmr064]

Paul, if the two pages are in different files, do the copy as you did initially, then use Edit|Links to take off the references to the first SS and point to the current file and Excel will do the work.