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

G

Guest

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

any help?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Sheet Values to new workbook 20
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Help with copying a sheet from One workbook to another workbook 1
enter key behavior - by sheet 4
Macro for all Excel Workbooks to print to PDF 2
save worksheet data to alternate closed workbook - next row 1
adding footer to all existing sheets in workbook and also to newsheets which is added 1

Top