Macro to populate Data from Columns into Rows.

Good Day

Please assist me with a Macro that will populate and calculate data that is in Columns into rows.

I have shown an example in the attached spreadsheet on how data is populated and how i want it to display the "Data" tab shows how i receive the data and the "Report" tab shows how i want the macro to pupulate the data

Thanking you in advance

Pitsere

Hi Arlu

I want the Data to be transfered from the "Data" tab into The "Report" tab. the "Data" Tab normally has thousands of Rows, so i want the information to automatically Calculate. please let me know if you require a demonstration of the "Before" and "after" look

Thanks

Good Day Arlu

I am Not sure if you received my response Yesterday>>>

- The "Report Tab is populated with information on Column A(Division), B(Category) and Column D (Season). the Macro needs to calculate All the Information from Column G onward based on Column A,B & D to Populate information accurately onto the Report Tab.

- The "Report" Tab's Rows are the Same as the Column headings from Column G onward in the "Data" Tab. in essence this is more like we are transposing information, the only difference is that the information is based on the conditions i mentioned about Column A, B & D.

Thanks

Hi Arlu

I have made an updated Example of how i want my Macro to look like.

Please see attached.

Thanks