Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter each item in a list
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
Running a macro for each item in an Autofilter list | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |