I have a data set where the number of rows will vary month. There are different dates in columns E and J. I'm looking for a macro that deletes all rows that have any date in column E (half or so will have dates and the rest will be blank). Then after that will delete all the rows that have a date where the day of the month in column J is later than the current day. For example row 4 has no date in column E but a date of 8/24/18 in column J. It will be deleted because the 24th is later in the month than the 17th (today).
I feel like I'm going about this very inefficiently by trying to get a macro insert a new column A then use a function like =if(B1="","Remove,IF(F1<>"","Remove",IF(DAY(TODAY())<DAY(K1),"Remove","Investigate"))). I'm still running into issues sorting that column then deleting all the "Remove" rows
Can someone please help?
I feel like I'm going about this very inefficiently by trying to get a macro insert a new column A then use a function like =if(B1="","Remove,IF(F1<>"","Remove",IF(DAY(TODAY())<DAY(K1),"Remove","Investigate"))). I'm still running into issues sorting that column then deleting all the "Remove" rows
Can someone please help?