G Guest Apr 18, 2005 #1 I have a workbook file with multiple worksheets. Can I save out a single worksheet into another file?
I have a workbook file with multiple worksheets. Can I save out a single worksheet into another file?
G Guest Apr 18, 2005 #2 try <edit><Move or copy sheet> select "Create a copy" if you want to leave the main sheet in the original select in "to book" select (new book) Depending on what you want to do with the new sheet and what extra sheet references there are in the sheet will influence what to do next. If all you want is a hard copy of what was in the original sheet I would select everything in the new sheet and copy and <paste special>< values>. If you want the sheet to be able to update from the original book leave as is. Save the new book by whatever name is appropriate.
try <edit><Move or copy sheet> select "Create a copy" if you want to leave the main sheet in the original select in "to book" select (new book) Depending on what you want to do with the new sheet and what extra sheet references there are in the sheet will influence what to do next. If all you want is a hard copy of what was in the original sheet I would select everything in the new sheet and copy and <paste special>< values>. If you want the sheet to be able to update from the original book leave as is. Save the new book by whatever name is appropriate.
