HI ALL,
I Have sheet 1 data same product various group sold we need
product wise sales lookup any one help me
If we add one more group it will come automattically please

I Have Sheet 1 data has like this

Product GROUP QTY AMOUNT
ABC OOOO 500 22500
ABC1 OOOO 100 4500
ABC2 OOOO 10 450
ABC AAAA 100 4500
ABC1 AAAA 200 9000
ABC2 AAAA 100 4500
ABC ZZZZZ 200 9000
ABC1 ZZZZZ 200 9000
ABC2 ZZZZZ 200 9000


I need out put like this SHEET 2

GROUP | OOOO | AAAA | ZZZZZ | TOTAL |

Product QTY AMOUNT QTY AMOUNT QTY AMOUNT QTY AMOUNT

ABC 500 22500 100 4500 200 9000 800 36000
ABC1 100 4500 200 9000 200 9000 500 22500
ABC2 10 450 100 4500 200 9000 310 13950

please reply my emailid
Best regards
chandru