Thread: How do I save a single spreadsheet in a workbook in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 1
Default How do I save a single spreadsheet in a workbook in excel

Hi,

Right Click on the report sheet. Select move or copy. Tick the copy
option. Next click the drop down "to book" and select the new book
option.

Then select all cells and copy, next right click and choose Paste
special and then values.

Hope that's what you wanted.

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561692

Reply With QuoteReply With Quote