CONVERT EXCEL DATAS INTO A SPECIFIC FORMAT

[PRADEEPB270]

Hans Sir,

Please refer my attachment.

In a attachment file,first sheet is working sheet and final sheet is populate first sheet data into this sheet.

Can it be possible through VBA Codes ?

Basically,construct final sheet with grand sum of Customer ,Business Area wise.

If a customer repeat more than 1 in a Business area, then, required grand total of these.

e.g.Customer code 10159,is repeating thrice in Business area-HHHD

[HansV]

Please make a start yourself, then come back when you run into problems.

[PRADEEPB270]

I have no idea to how to start.

I request can you help me in this matter ?

[HansV]

It is not the purpose of a board like this to provide complete solutions.

[PRADEEPB270]

I can understand.Really,I have no idea for VBA codes.

Is there is any solution other than VBA Codes ? If not,OK Let it be.

Thanks

[p45cal]

Is the table at cell H1 of the Final tab of the attached suitable?
What version of Excel are you using?

[PRADEEPB270]

Hans sir,

I have tried my best but see my attachment of MUSK.

It is not working as desired.Can you correct and tune fine ?

[HansV]

If you are able to write code like that, you should be able to modify it too...