Hi, Hope I can get some help with adding code to compare dates in column A of Sheet1 & Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro.
Sheet1 accumulates jobs with recommendations through out the year. Sheet2 accumulates completed recommendations. Any row on Sheet1 without a match needs to be followed up on. Duplications are appearing as highlighted on row 14. Since the job on row 14 took place on 1/24/19, the recommendation could not have been completed prior to that date. I've added the following;
Sub CompareDates()
If Sheet1.Range("A1") > Sheet2.Range("A1") Then
Run "MatchColumns"
End If
End Sub
But it's not working.
Any help would be appreciated as I'm a very novice user.
Bookmarks