[Ali Cat86[_2_]]

Is there anyway to put a dropdown list in a formula? Have it self populate in
a cell? I am trying to have it so you can choose a number in a drop down
list, in the next cell it generates the next drop down list, and continuing
for four cells.... I have 33 values which is much to large for the simple
formulas. Also, once this information is imputted, can it generate on another
worksheet in the workbook? For example, you Choose Building A, and the
information you place the cells generates on Building A's worksheet? Sorry
this is so complicated, but I am just trying to make this program as easy to
use as possible. Any advice is appreciated!

[T. Valko]

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Ali Cat86" wrote in message
...
Is there anyway to put a dropdown list in a formula? Have it self populate
in
a cell? I am trying to have it so you can choose a number in a drop down
list, in the next cell it generates the next drop down list, and
continuing
for four cells.... I have 33 values which is much to large for the simple
formulas. Also, once this information is imputted, can it generate on
another
worksheet in the workbook? For example, you Choose Building A, and the
information you place the cells generates on Building A's worksheet? Sorry
this is so complicated, but I am just trying to make this program as easy
to
use as possible. Any advice is appreciated!