Hi,

I'm setting up a linked list which works nicely between single cells,
however....
My columns are 1000 rows long and i really don't want to be adding in each
validation individually.
Is there a rather quick way for me apply the data validation taking into
account the linked lists as they need to reference a specific cell and not a
cell range?

So can the cells E16 to E1016 be filled quickly for the data validation to
reference cells D16 to D1016?