I have a workbook that has two dates in adjacent columns (D&E). I want to compare the two dates and if the date in Column E is > the date in Column D, I want to delete the entire row. I have no estimate of how many rows this workbook will have before it is done, so I need the macro to loop until the column A entry is blank ("").
If I can't delete the rows, I can live with clearing the contents and then I will resort the info to get rid of the blank rows.
Also, I would like for this macro to run when the workbook is opened.
Any help would be appreciated.
If I can't delete the rows, I can live with clearing the contents and then I will resort the info to get rid of the blank rows.
Also, I would like for this macro to run when the workbook is opened.
Any help would be appreciated.