Excel - validation list

C

CF

How can you dynamically create a excel validation list?

Example; given the below values in a rows you can create a validation
list that presents these values to the spreadsheet used in a combo-
box.
A
B
C
D

But if this list is dynamic and can be 20 rows but there are only 3
values I want to dynamically change the validation list to only be the
4 rows...

thx in advance!
 
Top