Searching Specific Column For Text - Then Adding Text Above IF Not Present

Depending on what the engineer experienced, they would press a button on their data recording application that would AUTOMATICALLY ENTER "Checkpoint" into the spreadsheet.

If that button was not pressed, there will be NO "Checkpoint" placed and the cells will remain empty.

In order to Calculate/finish my macro, I need to figure out how to add "Checkpoint" above the word "Signalized Intersection" BUT ONLY if "Checkpoint" already doesn't exist above the word "Signalized Intersection"

IMPORTANT NOTES: There will be ONLY THREE (3) "Signalized Intersections" on spreadsheet.

They are always in column G but never in the same row.

Some sheets will have NO "Checkpoints" at all, some will have TWO (2) "Checkpoints" etc.

There should ALWAYS be 3 Checkpoints in total (automatic or manually added) with 3 "Signalized Intersection" in total (aways automatically added)

EXAMPLE G
1
2
3 (NEED MACRO TO FIND THE SIGNALIZED INTERSECTION BELOW, MOVE 1 CELL ABOVE TO THIS SELECTION - THEN CHANGE VALUE TO "Checkpoint")
4 Signalized Intersection
5
6
7
8
9
10
11 (THEN SEARCH AGAIN AND FIND THE SIGNALIZED INTERSECTION BELOW, MOVE 1 CELL ABOVE TO THIS SELECTION - THEN CHANGE VALUE TO "Checkpoint")
12 Signalized Intersection
13
14
15
16 Checkpoint 'Automatically Entered From Engineer' - (SINCE THIS ONE WAS ALREADY ENTERED, DISREGARD AND SHUT OFF.)
17
18
19 Signalized Intersection
20

Sorry for the lengthiness, if this isn't clear enough... I will take some screenshots to help clarify.

I have code written for other elements, so I will be adding this new code to it.