Consolidation of Data from more than one worksheet file

  • Thread starter Thread starter Satya Nanduri
  • Start date Start date
S

Satya Nanduri

I have my company inventory on 15 different excel 2003 worksheet files. Is
there any way to consolidate those file and reports for each item? I do not
want the Pivot Table way. Because the structure of the worksheets is not
comfortable for that.

Satya Nanduri
 
Let's get the nomenclature down first
a file is a workbook
a worksheet or tab or sheet is the worksheet in the file.
You need so specify the workbook(s) and also the worksheet(s) within each
workbook.

for each wb in workbooks
worksheets("sourcesheetnamehere").copy somewhere
next wb
 
Well, I meant 15 workbooks (or as per your email they are different files
like Inventory1.xls, Inventory2.xls upto 15. I need to consolidate the data
and generate reports. I am not getting a logical way to do that. Sometime I
feel that doesn't make sense. But, wanted to try, if I am wrong.
Thanks for your time.
Satya
 
Back
Top