I have a report that has various tasks along the top and various sites along the site. The data in the table are forecast dates where they have dates.
I'd like to have the same report but only show dates less than a certain date (for example to show past dates or dates due this month, etc.). I'd like to have the macro show an input box where I can enter the date. But is it possible for the macro to then delete any dates that are greater than the entered date?
I know I can use conditional formatting to 'hide' the dates but I'd prefer them to be deleted instead - as it would help with my next task.
I fear this might need some sort of loop that would slow the macro down considerable?
Bookmarks