VBA to search a group of cells and input a message if a value is missing from the group

Hello;

I am very new at VBA. I am trying to write VBA code that groups cells between blank rows and inserts a message if a string of text (a name) is missing from the entire group. I want the code to search cells in column A and group the cells between blank cells. Use the name I input in an input box as the search criteria and insert a message in the Column C next to the last blank cell in the group and then move on to the next group and highlight the cell in red with bold text. I am including a spreadsheet with an example of what the sheet should look like before and after the code is run.

Any help would be greatly appreciated.

Can you show some examples, of some Names with extra data, as I would need to split each cell value to Isolate the actual name.

Here is an example of what the data might look like. See the information for Sarah Brown as an example. How would I get the code to recognize that Sarah Brown is in the group if there is additional information in addition to her name in the cell? Any help you could give would be appreciated.

Week 1 - Shift A
Supervisor: John Taylor
Zack Johnson
Allen Green
Ryan Harris
Sylvia Anderson

Week 2 - Shift B
Supervisor: Alex Sizemore
Sarah Brown
Zack Johnson
Allen Green
Sylvia Anderson

Week 3 - Shift C
Supervisor: Janice Cooper
Sarah Brown ph.555-613-1212
Zack Johnson
Allen J. Green
Ryan Harris
Sylvia Anderson

Week 4 - Shift A
Supervisor: John Taylor
(Supervisor Fill In) Sarah Brown
Allen Green
Ryan Harris
Sylvia Anderson

Week 5 - Shift B
Supervisor: Alex Sizemore
Sarah Brown (Late 10 minutes)
Zack Johnson
Allen Green
Sylvia Anderson

Try this:-

Please Login or Register  to view this content.

Regards Mick

Mick;

Thank you for all your help so far. Unfortunately the code did not work. It stopped at

Please Login or Register  to view this content.

. I cannot see in the code where Nam or n are set and used. Not sure how to fix. Any other suggestions?

If one of the groups only consists of one line, then try this:-
Otherwise please sent example file.

Please Login or Register  to view this content.

Mick;

I figured out the problem. Thank you so much for your help!
Regards;

Nancy

You're welcome
What was the problem ???

Typo in the code - wrong column reference. It works perfectly now. Thank you again for your help.

Thanks for the feedback, glad its working.
Regrds Mick