MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!

Posted by Ryan on June 20, 0100 9:27 AM

Don't know if this is what you are looking for, but you could include a WorkSheetChange Event to watch the cell that they pick their division from. In this Event procedure you can call another procedure that filters the data below.