convenient way to provide "list of values"
convenient way to provide "list of values"
(OP)
Is there a convenient way to provide a "list of values" for data entry. For example choices may be limited to "pump", "motor", "fan" and I would like to provide some flexible prompt.
I tried using data / validation / list but it appears limited to lists that are in the current worksheet. I would like to store a list of acceptable values in other worksheet in same workbook but can't figure out how to do that.
I tried using data / validation / list but it appears limited to lists that are in the current worksheet. I would like to store a list of acceptable values in other worksheet in same workbook but can't figure out how to do that.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.





RE: convenient way to provide "list of values"
RE: convenient way to provide "list of values"
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: convenient way to provide "list of values"
Find an unused area of the worksheet/book and type in the list of allowable values. It could be on a different sheet. Define a name for the list (the easiest way is to highlight the entire list, go to the name box at the upper left of the row/column headers, type in the desired name and hit enter). (say you use "Allow_val")
Now go to the cell(s) where you want to restrict the input to the list. Go to Data>Validation, select "List", and in the formula bar of the dialogue type "=allow_val"
That should take care of it!
RE: convenient way to provide "list of values"
RE: convenient way to provide "list of values"
Thx.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: convenient way to provide "list of values"
RE: convenient way to provide "list of values"
for details on dynamic named ranges, see the following website:
http://www.ozgrid.com/Excel/DynamicRanges.htm
btw, i do frequently use dynamic named ranges and data validation lists. oh, dynamic named ranges are also useful for charts.
good luck!
-pmover