Forum Discussion
Data Validation triggering a macro
You can create a Worksheet_Change event procedure in the code module of the worksheet with the data validation drop downs.
If you would like help with that, please provide more detailed information. Attaching a sample workbook would be useful.
Hello Hans, thank you for your prompt response. Please see attached a sample workbook. It contains notes of what I am trying to achieve. I look forward to your reply.
Krishna
Maybe you could use a query to filter the list and remove the columns you don't want in the results? You could use the worksheet_change event handler to refresh the query when you make changes to the "Re-sort" field on the original table (right click on the Dockets_In tab and select view code), or refresh it manually when you need to.
I'm not sure where the "Resort Run" information comes from in the results, so I don't know if that's something that could be added to the query itself (I don't have much experience with queries, but someone else may be able to help with that).
