Posts2Registration dateTuesday December 4, 2012StatusMemberLast seenDecember 4, 2012
Dec 4, 2012 at 06:16 AM
Posts1Registration dateTuesday April 30, 2013StatusMemberLast seenApril 30, 2013
Apr 30, 2013 at 03:17 AM
I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When I apply Autofilter to select top 10 locations based on volume, I get the top 10 locations.
But, the problem appears, when I copy the top 10 locations and related volume. By default only top10 locations should be selected, but excel selects all of them. But when I click on "Reapply" Filter, it can work well. Is it because of my Excel setting issue? Please advice if you have been experience this issue before.
Thanks in advance.
Unable to copy selected cells after apply autofilter function