I have dates in Col F on sheet2
I have manually filtered the dates prior to 01/10/2017 (dd/mm/yyyy) and then manually deleted the rows
I would like to automate this process so that a message will appear "select date you wish to filter prior to this date"
once this is inputted , Col F must be filtered and the date filter must filter all the dates prior to the date inputted into the message box
for eg all dates prior to 01/10/2017 and then delete these rows
Your assistance in this regard is most appreciated
I have manually filtered the dates prior to 01/10/2017 (dd/mm/yyyy) and then manually deleted the rows
I would like to automate this process so that a message will appear "select date you wish to filter prior to this date"
once this is inputted , Col F must be filtered and the date filter must filter all the dates prior to the date inputted into the message box
for eg all dates prior to 01/10/2017 and then delete these rows
Your assistance in this regard is most appreciated