Home |
Search |
Today's Posts |
#1
|
|||
|
|||
consolidate 2 different workbooks
Can any one help me?
I want to consolidate 26 workbooks into one new summary sheet. If the same product code and colour exits in the 2 workbook add the values together, but if the product code has a differnt colour insert into a new row. |
#2
|
|||
|
|||
Ron de Bruin has lots of sample code at:
http://www.rondebruin.nl For combining worksheets from various workbooks. You'll find some code that opens the workbooks, and copies the cells from one worksheet at the bottom of a summary sheet. Once you do this, you might be close enough to use Data|pivottable to get your summaries. JackieB wrote: Can any one help me? I want to consolidate 26 workbooks into one new summary sheet. If the same product code and colour exits in the 2 workbook add the values together, but if the product code has a differnt colour insert into a new row. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |