G
greg malenky
Michael
On a seperate part of the worksheet put your four
variables in a column:
a1 - 350
a2 - 450
a3 - 850
a4 - 1200
then use a data validation list in the cell you want the
variables to list
go to "data" - "validation" - under the "settings" tab
select allow -"list"
in the "source" field put a1:a4 (or whereever your
variables are located).
this will create the drop down list you want.
On a seperate part of the worksheet put your four
variables in a column:
a1 - 350
a2 - 450
a3 - 850
a4 - 1200
then use a data validation list in the cell you want the
variables to list
go to "data" - "validation" - under the "settings" tab
select allow -"list"
in the "source" field put a1:a4 (or whereever your
variables are located).
this will create the drop down list you want.