using ws.copy and pasting into a new worksheet as values

[mjschukas]

using ws.copy and pasting into a new worksheet as values (i.e., paste special values--breaking all the links/references)

???

thank you.

 

[erik.van.geit]

what's the question?

 

[mjschukas]

copy a worksheet to another workbook and delete/break all ..

i would like to copy a worksheet to another workbook and delete/break all the cell references...

????

thanks.

 

[diverdave]

copy your information and then one new worksheet use:
"Edit"
"Paste Special"
"Values"

this will enter the data but no formulas or references to the original worksheet

 

[actjfc]

I believe that you can use this post to solve your problem.

http://www.mrexcel.com/board2/viewtopic.php?t=24239&highlight=