transpose data between excel workbooks using macro

[karthikgoel]

Looking for help with Macro that can copy data from my source excel into target excel as below
Data in my source file looks like this
Region | Month | Category | T1 | T2 | T3 | T4
US Apr-14 Actual 1 2 3 4
US Apr-14 Forecast 5 6 7 8
US May-14 Actual 1 0 0 0
US May-14 Actual 2 0 0 0
..... so on

I want to copy data from above Columns T1 to T4 into predefined target workbook with header like below and KPI cells are fixed with T1 to T4 etc.

Region KPI Apr-14(Actual) Apr-14(Forecast) May-14(Actual) May-14(Forecast)
US T1 1 5 1 2
US T2 2 6 0 0
US T3 ...
US T4 ...

 

[Debraj]

Hi Karthik..

can you please upload a sample file with expected output..

creating a file, as per your requirement and then start working is lil bit time consuming..