Sorry. I have re worded my original comment.


I have already tried something like this - the
issue is I can but the values in for the first empty row (a1,b1,c1,d1) however
when someone fills in the second name in row 2 they don't have to fill
in everything as row 1 is already full.
If I put in rows 1-8 (for example) what happens of I only want to
fill in rows 1 and 2 . And then what happens when Someone fills in row 9
incorrectly.

Do you see my dilemma? I need something that says if column a is full on
a particular row then columns b,c,d also need to be full on the same row.