consolidate 2 different workbooks

[Guest]

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]

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.