PDA

View Full Version : Extracting data from a Sheet-VBA Help



sethu29
08-05-2016, 12:09 AM
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
08-05-2016, 05:27 AM
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
08-08-2016, 05:38 PM
You could use a pivot table

16821