Save a sheet of a workbook to a sheet in a new workbook
 

Does anybody know a methode how I can save a sheet with links to an other
sheet without these links?

any help?

Save a sheet of a workbook to a sheet in a new workbook
 

Danny,

This isn't a VBA solution, but when I have to do that I do the following:

I do a sheet copy -- the whole sheet. Then on the copy of the sheet I
highlight everything, copy and paste values. This won't do formulas for you.


"Danny Verswyvel" wrote:

Does anybody know a methode how I can save a sheet with links to an other
sheet without these links?

any help?