How can I loop through each item in an autofilter list?
I am sending data from Access then need to filter and copy to individual
sheets. The filter column will contain different data everytime. I thought
about copying the unique values to a range on the side and looping through
that as Criteria1. I was hoping there was a way to loop through the dropdown
directly.