| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine files as tabs in a single Workbook
I have 3 Excel files in a folder. I wanted to setup some kind of macro or
programming to combine the three files as three tabs in a single file. Could someone kindly assist me on this. 2 of the excel files have 2 tabs each and one file has 1 tab. So when they are combined it makes one file with 5 tabs. In effect I will have 20 folder each with 3 files -structure will be the same that is 2 files with 2 tabs and 1 file with one tab and they are to be made into one file with tabs. Thanks so much for your help Sam Commar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up single Header/Footer for all tabs in Excel Workbook. | Excel Worksheet Functions | |||
| how can I combine multiple worksheets into a single workbook? | Excel Discussion (Misc queries) | |||
| Trying to write macro to combine data in multiple tabs into a single tab. | Excel Programming | |||
| merging single worksheet files into a single workbook | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Threaded Mode
