Connect values from sheets to a drop-down list

Originally Posted by Glenn Kennedy

It is do-able. I have a way of doing it. there may be a better way that someone else can come up with. I have to eat now. Look back later (1 hour) or in the morning.

no problem, thanks for looking into it, will try some things myself during the meanwhile