Save a worksheet from workbook

[egeslani]

I have a workbook with about 45 worksheets. If I need to save a certain worksheet to another workbook, I used to save the whole workbook with new name and delete the worksheets that I don't need. Is there another way to do it?

Thanks,
Ernie

 

[waggy30]

To do it just create the new workbook, rightclick on the sheet tab that you want, and select 'Move or Copy'

 

[robfo0]

yeah, :
1.right click the worksheet you want to save by itself
2. click move or copy
3. under drop down menu "to book" select "(new book)".

then you have that sheet in a different book. If you check the copy box, it will copy it to a new book, but leave the original in your big file.

 

[dk]

You could click Edit, Move or Copy Sheet and select New Book from the first drop down box. Make sure you tick the Create a Copy checkbox as well.

HTH,
D

 

[egeslani]

Thanks to all you guys.