Table on the basis of raw data..

Dear Sir,

Thanks for earlier help.

Another help required.

Have raw data in enclosed sheet westzone.xls->Raw Data. Wanted to create report exactly as per format displayed in sheet-->Final Report.

Tried to create the same through Pivot table. but every time I landed in something different.

Also tried to create the details required for this final sheet by using vlookup function and manually, but it is getting complicated when the verification of the data comes in picture.

But what to do when it runs through around 1000 record. Also it takes lot of time and energy to create this.

Guide me to create this automatically through macro or pivot.

Please help me.

Thanks and Regards,

KB Manwatkar

Hi there,

please find the solution atached. What I did is highlited in red.


Best regards from HAmburg

Dear Sir,

Great help. Thanks.

I was also able to derive outcome with the help of Vlookup with some manual work.

If there are hundred of entries, it becomes difficult as the required output for each account number needs to be copied down manually. Can you please help me in replicating the outcome for each account numbers in Raw Data.

May be some small macro or some other trick would help in this.

Thanks once again..

Kind Regards,

KB Manwatkar