I have created a macro that allows me to manipulate a large data table into the format I need. Currently the date range it selects is fixed however for each report I run I may want to select a different date range.
How do I get the macro to bring up the filter box (like the example pictured below), allow the user to tick the desired dates and then let the rest of my macro continue? The filtered cell is always R1
Any help would be greatly appeaciated
How do I get the macro to bring up the filter box (like the example pictured below), allow the user to tick the desired dates and then let the rest of my macro continue? The filtered cell is always R1
Any help would be greatly appeaciated