Auto Sort Filtered Sheet

dojones

Create method to auto sort a filtered sheet. If date is selected for sorting and Status field is filtered to Open. Current method is to turn filter off, select date field, select sort, select OK, change filter back to Open. I would like an automatic sort/workflow to accomplish this.