Home |
Search |
Today's Posts |
#1
|
|||
|
|||
TO split worksheets in a single file to multiple files
Hi Dear Friends,
I have attached a spreadsheet file, which has multiple sheets named-Harry, Steve, Thomas etc I will need a technique where I can split this single file in to multiple files based on the worksheets within the original single master file. So once I have the split, I would like to the files to be named based on the names in the master file example- Harry.xls, Steve.xls, Thomas.xls This is just a sample file, I will have a huge number of worksheets (16 nos) in the master file and I occasionally do add and delete worksheets from the master file Any help will be greatly appreciated Thanks Dumbo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TO split worksheets in a single file to multiple files
Hi Dear Friends,
I have attached a spreadsheet file, which has multiple sheets named-Harry, Steve, Thomas etc I will need a technique where I can split this single file in to multiple files based on the worksheets within the original single master file. So once I have the split, I would like to the files to be named based on the names in the master file example- Harry.xls, Steve.xls, Thomas.xls This is just a sample file, I will have a huge number of worksheets (16 nos) in the master file and I occasionally do add and delete worksheets from the master file Any help will be greatly appreciated Thanks Dumbo +-------------------------------------------------------------------+ Filename: How to Split worksheets in to separate files.zip | Download: http://www.excelbanter.com/attachment.php?attachmentid=1001| +-------------------------------------------------------------------+ Do you want to 'move' the sheets or 'copy' them? Either method opens a new workbook with the sheet being moved/copied, and this becomes the ActiveWorkbook. Simply do a 'SaveAs' and close the file. If moving you'll need to leave the last sheet in the original file and do 'SaveAs' because Excel won't allow an empty workbook (ergo no sheets)! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to split a large excel file into multiple smaller exel files. | Excel Discussion (Misc queries) | |||
Split a worksheet into multiple worksheets of the same Excel file | Excel Discussion (Misc queries) | |||
Split a worksheet into multiple worksheets of the same Excel file | Excel Programming | |||
Printing multiple worksheets to one single pdf file | Excel Discussion (Misc queries) | |||
Extracting a single file from a zip archive which has multiple files | Excel Programming |