Extracting data from a Sheet-VBA Help

[sethu29]

Hai Support,

I've attached an excel Sheet. There is raw data sheet with Date,Company,Vch Type,Vch No,Credit.

There is a summary sheet in the same workbook. In Which, If i select Company, VBA need to extract the list Bill no/Amt as per the format mentioned.

Please help. I've attached Excel Workbook

[Kenneth Hobs]

Wouldn't a simple Filter on the Rawdata suffice? If so, hide columns you don't want and if you needed the running count, SL No, then add/insert a column in Rawdata, say A.
A2=COUNTIF(C2,C2)
=COUNTIF(C$2:$C3,C3)
and fill down.

[Paul_Hossler]

You could use a pivot table

Capture.JPG