Need Macro for concatenating multiple worksheet

G

Guest

I am hoping someone out there can help me. Thank you in advance.

I have a workbook with multiple tabs. Each tab represents a different
"SOURCE" of data.

Each tab has header information:
F1 = Country
F3 = Month
F4 = Source (corresponds to tab name)

The actual Data resides in columns B:E starting a row 9 (B9:E9).
Column B = Code
Column C = Product
Column D = Units
Column E = Value


Basically I have a workbook for each country
Each workbook has one tab for each Source.
Depending on the country, there number of tabs will vary.

I need to transform the data so that it fits into a normalized table.
I need to have all tabs combined into one new tab that looks like this.

Column A = Month
Column B = Country
Column C = Source
Column D = Code
Column E = Product
Column F = Units
Column G = Value

Thanks again.
 

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

Similar Threads

Excel Subtracting multiple columns from another column 3
find multiple data cells for one data source 8
Macro: finding a cell on one worksheet and copying to another worksheet 0
Multiple Date Columns in Excel 3
IF Statement Problem 4
Desperately Need Excel Formula Help! 3
Moving data from one sheet to another 2
Summary Sheet - Total Multiple Sheets 6

Top