Hi
I have a table with autofilters. For column A I would like, in VBA, to choose each item one by one until all have been looped through. Is it possible? i.e. choose number one item in the autofilter-list "colA" (without knowing the name of the item), I then do some copy paste of those filtered values to another sheet, next number two on the autofilter-list is choosen and the corresponding filtered values are copied to another place and so on.
Any ideas?
I have a table with autofilters. For column A I would like, in VBA, to choose each item one by one until all have been looped through. Is it possible? i.e. choose number one item in the autofilter-list "colA" (without knowing the name of the item), I then do some copy paste of those filtered values to another sheet, next number two on the autofilter-list is choosen and the corresponding filtered values are copied to another place and so on.
Any ideas?