Hi Brablo,

in steps:
1) select the range of the states (Sheet2 A1:A51)
2) either Insert / Name I> / Set/Give Names > then you can gve 1 name to the
selected range (e.g. TheListOfStates)
3) then on sheet1 go to the cell, where you want the pulldown menu and
4) Data / Validation / select List and for the source just type:
=TheListOfStates and confirm with OK.
5) copy the validation to all cells you want the same pulldown list.

i am sure you can do it :-)

Best regards,
ANdras
(Hungary)


"Brablo" wrote:

> I'm not sure if I can implement this.
>
>