Look for blanks & return the person's name on a sheet

I have a worksheet called "Esclation Rotation" where it has my associates names & the date they covered the esclation line. On sheet "control" i have in cell "I12" the person who supposed to be next in rotation. Basically I need it to look and pull the next 3 people with a blank beside their names. Then if they covered the esclation line, when they click on the checkbox next to their name on "control" that it was completed, I would like for it to put the date which is in cell "C3" into the cell that was found blank. Any help would be greatly appricated. I have uploaded an example book for your referenece.

Here is a sample file of what I have available. Please assist!

Please do - didn't know if it would be VBA of if there was a formula that could be used.

This is a 2-part question. Part 2 will have to be solved through VBA.

Part 1, filling in the names, might be achievable through the use of formulas but you will have to un-merge the cells in I12:L14.
You can always use "Center Across Selection" to mimic the look of merge and center.

Based on the sample that you shared in post #3, what names should go into I12:L12?

As you can see, 2 out of the next 3 blank cells have a duplicate name (PAUL TOTH).
Should this name be repeated or should we pull the next unique name with a blank cell next to it?

Great, it would be the next unique name with a blank beside it.

I can help with Part 1.

After un-merging the cells in I12:L12, try this in I12:

=INDEX('Escalation Rotation'!A$2:A$204,MATCH(0,COUNTIF(I$11:I11,'Escalation Rotation'!A$2:A$204)+('Escalation Rotation'!B$2:B$204<>""),0)) Ctrl Shift Enter

Drag this formula through I14 and then fix the formatting accordingly.

What if I wanted it to count Paul again so my results would be Paul Toth, Brianna Bivens & then Paul Toth again?

That (post #10) would look like this:

I12 =INDEX('Escalation Rotation'!A$2:A$204,SMALL(IF('Escalation Rotation'!B$2:B$204="",ROW('Escalation Rotation'!B$2:B$204)-ROW('Escalation Rotation'!B$2)+1),ROWS($1:1))) Ctrl Shift Enter

Same thing, drag the formula down and then adjust the formatting.

Great that works flawlessly - now just need the completed checkbox, if it is checked for it to put the date in for that person from the C3 cell on control - any suggestions or assistance would be greatly appricated!

What if I put a completed? the line in Colum M12 - so the associate could put the date completed and on cell change it would copy that date over to "Escalation Rotation" beside that associate?

Thanks for the rep!

Since this is a 2-part question, I think that it would be appropriate to create a new thread in the VBA section where you can ask about part 2 (check-box automation).

Include what you have so far with the formulas in place. You can provide a link to this thread if you think that will help future contributors.