I have a huge raw data in "GQC sheet" and need help to make report like below "Report sheet". to find total sale depend on Order no, and party name, when I write a Order No. in my 'Report sheet' in cell D2, report will prepare automatically in "Report sheet", like my example "Report". plz see attach file color indication in GQC & report sheet .
Order No. 51530
Order No.Party Name Sale Return Total sale
51530 Mills 297 - 297
51530 Wear 620 - 620
51530 Polar 44 - 44
51530 Ocean 98 - 98
Note: I do not want to use pivot table for this case, coz, there is huge number of data in GQC sheet and number of report huge that's why i wanna do it by VBA,, Really I need some one help. Thanks in advance.