Hi
I have an Excel sheet which has Category Column, I have set an auto filter for it, When I click a particular Category data pertaining to that Category is visible.
But my problem is I need help (VBA), that loops category autofilter, through each Category item and capture(sum number of items in that particular category) and put it in an other excel sheet. Kindly Help.
regards
Phi