Hi,

I have some Items in the Excels sheet and status for those items. The Items are in different rows.i.e, Items List 1,ItemList 2, Item List3 etc....for each item list there is a status column also. I want to get the count of the items which are having status='NO' and i should be able to list top 3 items. And when i click on the count it should drill down and display the corresponding item(Drill down part is very important for us). How can i do this in Macro coding? Is pivot table required for this?


Thanks,
Nithin Ramesh