For example an entry is made in P26, I want Q26 to be
given the validation list, also if a subsequent entry is
made in Q26 I then want R26 to get the validation.

That's what the code I posted (if you modified it for more
rows) does, unless we're misunderstanding one another.

Merjet