Run Macro to filter data based on Data Validation
Posted by M Perry on June 20, 2000 9:17 AM
Hope someone can help.
Is there a way to automatically filter a list of data based on data validation, much the same way as would automatically happen if my data was a pivot table?
I can't use a pivot table because I the report I am generating is interactive (i.e. requires input from the field). Additionally, other variables not in the list depend on the data validation (which I currently have working on VLOOKUPs from a table).
So, I'd like the user to choose their division from the data validation cell and I'd like that to automatically filter the list below to their division's data.
Any ideas anyone? Thanks!