| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Combine 2 Spreadsheets into two worksheets
Hi - Is there any way to automate using a macro the procedure to combine two
separate workbooks into one workbook where the separate workbooks are now on separate worksheets? I know how to manually do this but need to automate this for our operators who will be running this process on a weekly bases. I'm capturing conditional data using MONARCH, exporting it out to a flat file, importing flat file into an ACCESS program slices & dices the information according to the requirements then exports it out into two separate workbooks. Since I'm trying to avoid these operators from having to open any files to manually manipulate the data (too time consuming - it produces over 20 files) I'm looking for other alteratives. I greatly appreciate any suggests. Thanks in advance Uni |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to combine data from 2 spreadsheets | New Users to Excel | |||
| How can I automate copying data from one into several spreadsheets | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets? | Excel Discussion (Misc queries) | |||
| How to automate footers (filename/date) for all new spreadsheets? | Excel Worksheet Functions | |||
| Combine two spreadsheets using Macro | Excel Worksheet Functions | |||
Threaded Mode
