VBA Extracting Data from large set of data

[Praveen kammar]

Hi All,

I have to run a report every week with new data every time, I have the below data for example.

Please see the Raw Data sheet in the attached spreadsheet.

When I run a report it need to generate a new spreadsheet for different clients with the below result with the format.

please see the expected result sheet i the attached spreadsheet.

Can any one please help me with a VB code to get the expected result.

Many thanks,
Praveen

[tigeravatar]

Praveen,

Welcome to the forum. For this request, I'd recommend using a Pivot Table

Hope that helps,
~tigeravatar

[Praveen kammar]

Hi

I am currently using pivot table, but I want it to happen in a click of a button.

Please help.

Many thanks,