Hello,
I am trying to build a macro that will contain a section that will prompt the user for a date (MM/DD/YY) and then look at a column in the current active sheet and DELETE the row if the date is greater than or equal to the input date.
I will have a header row.
For the sake of VBA build, let's say that the header row runs from (A1) through (P1) and that the date column is column (G)
Also the date format in Column (G) is the Short Date format in Excel.
Everything I've googled and tried does not delete the rows if column (G) contains a date greater than or equal to the input date.
If you can, make the Dim PED As Date (PED = Period End Date)
I'm trying to get one built from scratch if I can. Any help is appreciated!
Thanks!