I have a data validation list that works fine, however, when the data is filtered I want the validation list drop down box to only show the filtered items.
Example:
Sheet "Inventory" - Shows items in inventory (which the user can filter.)
Sheet "Sales" - This is where the validation list is located, taking the items in the Inventory worksheet.
I want the items in the Sales drop down validation list to only show filtered items in the Inventory list. I do not want to use a macro to do this.
Thanks!
Bookmarks