Hi,
I've been trying to do this for 3 days with no luck. any guidance would be greatly appreciated.
I'd like the macro to prompt a dialogue box to ask for 3 things ID, Start Date and End Date.
When entering these data points a table on another sheet called "Data Sheet" will look for the ID in column B and start and end dates in column K and only keep the rows that match those parameters while deleting all others.
For example if my ID is 1 and the start date is 1/1/2018 and end date is 6/1/2018 I want to only keep rows that have that ID and are within the dates in column K.
If there is no matching criteria then the dialogue box would read "Criteria not found"
Thanks!!
I've been trying to do this for 3 days with no luck. any guidance would be greatly appreciated.
I'd like the macro to prompt a dialogue box to ask for 3 things ID, Start Date and End Date.
When entering these data points a table on another sheet called "Data Sheet" will look for the ID in column B and start and end dates in column K and only keep the rows that match those parameters while deleting all others.
For example if my ID is 1 and the start date is 1/1/2018 and end date is 6/1/2018 I want to only keep rows that have that ID and are within the dates in column K.
If there is no matching criteria then the dialogue box would read "Criteria not found"
Thanks!!