I have a sheet with the basic Excel filter enabled on the top row (the one under Sort and Filter
on the ribbon).
When I run a VBA procedure, it clears the data on this sheet and replaces it with new data. This also removes the filter.
Is there a way I can apply this simple filter drop-down option using VBA by applying it to a range, or conditional formatting?