| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining 11 "like" workbooks...
I have 11 workbooks that have the same column's for A-L. Unfortunately,
since the workbooks were generated by a system - they technically have 255 columns but only the first 12 are populated. I need to (quarterly) combine the information from row 3 to the end for all 11 into one "master" spreadsheet. I've then created a pivot table to report off that one master. I started writing a macro that would combine the multiple workbooks but am concerned since the # of rows will vary from quarter to quarter. Any recommendations on the easiest way to accomplish this? Thanks! Michelle |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining 11 "like" workbooks...
Hi Michelle
Try this add-in or the code in the links on the bottom of the page http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michelle" wrote in message ... I have 11 workbooks that have the same column's for A-L. Unfortunately, since the workbooks were generated by a system - they technically have 255 columns but only the first 12 are populated. I need to (quarterly) combine the information from row 3 to the end for all 11 into one "master" spreadsheet. I've then created a pivot table to report off that one master. I started writing a macro that would combine the multiple workbooks but am concerned since the # of rows will vary from quarter to quarter. Any recommendations on the easiest way to accomplish this? Thanks! Michelle |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining 11 "like" workbooks...
This looks great - thanks! I'll give it a try this morning...
Michelle "Ron de Bruin" wrote: Hi Michelle Try this add-in or the code in the links on the bottom of the page http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michelle" wrote in message ... I have 11 workbooks that have the same column's for A-L. Unfortunately, since the workbooks were generated by a system - they technically have 255 columns but only the first 12 are populated. I need to (quarterly) combine the information from row 3 to the end for all 11 into one "master" spreadsheet. I've then created a pivot table to report off that one master. I started writing a macro that would combine the multiple workbooks but am concerned since the # of rows will vary from quarter to quarter. Any recommendations on the easiest way to accomplish this? Thanks! Michelle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
