Analyzing data from multiple workbooks with multiple worksheets

[charbaugh]

I am openly an idiot when it comes to programming VB and need some help. I have 3 workbooks, lets call them 2011file, 2012file, and 2013file. In each workbook, there are 20-30 tabs, each one representing a vendor of mine. Each tab is identically formatted for columns, etc. What I want to do is search through all of the sheets of each workbook for a specific value in the 'part number' column (F), and then return the total sum of the $ amount that is found in the 'delivered amount' column (R). Basically, I need to be able to show the total revenue for a specific part for each year. Hopefully to make this simple, I only need one specific part, so that text can be hard coded into the macro. I don't need it to be variable in any way.

Can someone point me in the right direction? I appreciate any help in advance.

[oeldere]

What about putting all data in 1 workbook in a summarysheet.

Then you only has to look in the summarysheet (of the 3 workbooks.

[charbaugh]

That would work. Still don't know how to get the data I need, though.

[oeldere]

Could you post an example of your file, wihtout confidentional information.

[charbaugh]

Here is a sample file that has been scrubbed. The normal files have 20-30 sheets in them, and in each sheet there may exist blank rows.



Book2.xlsx

[oeldere]

Maybe like this, see the attached file.

Please Login or Register  to view this content.

[charbaugh]

Thanks! That's exactly what I needed.

[oeldere]

Thanks for the reply.

Glad I could help.

You can add points to the rep(utation) of the members who helped you by clicking on the star.