| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving multiple worksheets as separate files
I have an excel file that someone put 100 or more sheets in the file. I need
to know how I can extract all the worksheets at the same time as separate files that I can name maybe file1.xlsx, file2,xlsx etc. Right now I have to move or copy each sheet one at a time and that is slow. Thank you in advance for your help. Pauline Moreno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open multiple excel files as separate tasks on the taskbar? | Setting up and Configuration of Excel | |||
| Macro help - Moving 2 cells from 100 separate files into new folder | Excel Discussion (Misc queries) | |||
| Merge worksheets from separate files into one workbook. | Excel Discussion (Misc queries) | |||
| How do I separate worksheets in a workbook into individual files? | Excel Worksheet Functions | |||
| separate worksheet into multiple worksheets by grouping | Excel Worksheet Functions | |||
Threaded Mode
