Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet to new file
I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this. Jai |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet to new file
Use the macro
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jai" wrote in message ... I have more than 100 worksheet in a sheet and i want to save this worksheet as workbook at once. I can do I one by one. Please help me on this. Jai |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet to new file
Right click on the worksheet tab you wish to copy and select Move or Copy
from the short cut menu. At the top of the dialog box, drop-down the list in the To Book combo box and select New Book, and then click the Create Copy check box at the bottom so it copies the worksheet. Then click OK -- Kevin Backmann "Ron de Bruin" wrote: Use the macro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jai" wrote in message ... I have more than 100 worksheet in a sheet and i want to save this worksheet as workbook at once. I can do I one by one. Please help me on this. Jai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
How to get file name on a worksheet? | New Users to Excel | |||
How do I display the file name in the worksheet? | Excel Discussion (Misc queries) | |||
Saving to a worksheet in another file...? | Excel Discussion (Misc queries) |