This may need programming to do but I am not sure. I have a column, C,
of 150 cells each with a data validation linked to a named list, lets
say X, Y Z being the values in the list. What I would like ideally is if
there is a value in cell A1 for example, then the first value X of the
data validation list should appear in cell C1. Same for A2 and C2, A3
and C3, and so on. Every time it is simply the first value of the drop
down list that appears in the cell. If the user wants to change to Y or
Z then he has the drop down selection option. I am aware I could
probably do it with a control toolbox combo box but there are 150 cells
with data validation in the column which I do not think would be
suitable in this situation.
I value any guidance.

Kind Regards,
Graham Haughs
Turriff
Scotland