Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I append multiple sheets from mulitple xls. files. into 1
I have multiple xls. files that have multiple sheets. I want to consolidate
into one file with a number of sheets. How do I do that? Can it be done without buying a add in? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I append multiple sheets from mulitple xls. files. into 1
You can do it with a macro or a lot of manual work. However, you may not
want to make the file TOO big especially if you have memory constraints. More info? -- Don Guillett Microsoft MVP Excel SalesAid Software "salem_gladiator" wrote in message ... I have multiple xls. files that have multiple sheets. I want to consolidate into one file with a number of sheets. How do I do that? Can it be done without buying a add in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Overwrite / Append files? | Excel Discussion (Misc queries) | |||
How to append/combine (not add) data in several sheets into one? | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) |