| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Consolidate Worksheets
One of the software systems I use generates more than 20 single-sheet CSV files each month. Is it possible to write a simple macro that when executed will consolidate all of these single sheets into a new workbook containing one sheet per CSV file? Any help would be much appreciated! -- andrewc ------------------------------------------------------------------------ andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613 View this thread: http://www.excelforum.com/showthread...hreadid=557859 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Consolidate Worksheets
Hi Andrew,
Ron De Bruin has sample code at: http://www.rondebruin.nl/copy3.htm#sheet See particularly Examples n11 and 12. --- Regards, Norman "andrewc" wrote in message ... One of the software systems I use generates more than 20 single-sheet CSV files each month. Is it possible to write a simple macro that when executed will consolidate all of these single sheets into a new workbook containing one sheet per CSV file? Any help would be much appreciated! -- andrewc ------------------------------------------------------------------------ andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613 View this thread: http://www.excelforum.com/showthread...hreadid=557859 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help on consolidate worksheets from different workbooks into one | Excel Discussion (Misc queries) | |||
| consolidate multiple worksheets | Excel Worksheet Functions | |||
| How to consolidate all worksheets data into 1 worksheets? | Excel Discussion (Misc queries) | |||
| How can I consolidate three worksheets into one? | Excel Discussion (Misc queries) | |||
| I need to consolidate data from 3 different worksheets? | Excel Worksheet Functions | |||
![andrewc[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
