Popup box asking the effective date, so macro can delete any dates < entered date.

Hi,

I have team data which I pull up from some application. But the data gets pulled up from beginning of the year. I have already ran a macro which does some other thing before coming to this step where i need to delete previous months data so I can work on current month only.

Is there any coding which popup the input box where I can enter the date and VBA delete the entire rows which is <then date entered in input box?

Thanks

Hi.

One way would be to just add a DatePicker control to your sheet and let the Date you select be the Criteria in the Autofilter.

Say your data is in Columns A:J and the column headers are in row 2..

Assuming your Date column is in Column A... you could use something like this..

Please Login or Register  to view this content.