Looking to do:
1: First, detect row used as header title row (it varies from sheet to sheet, could be anywher between rows 1-10). It can be detected by searching for the text "Space ID". Whatever row that appears on should be treated as the header row for the rest of this script. The reason this will work is because "Space ID" is a constant header title in every workbook, and can be used as a reference point to find the row the rest of the header titles are in.
2: Using the determined header title row from above, find the column titled: "Last Check".
3: For every row in the "Last Check" column identified above that has a value of "Overdue", save that row as a variable to be used in step 5.
4: Using the determined header title row from step 1, find the column titled: "Status".
5: For every row flagged in step 3, change the value (on each row) under the column "Status" to "Over".
6: IF no "Overdue" values were found/changed, then continue as normal.
If ANY "Overdue" values were found/changed, then call sub (my message box sub), then continue as normal.
Bookmarks