Consolidation of Data from more than one worksheet file

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
 
D

Don Guillett

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
 
S

Satya Nanduri

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top