Creating pick box with unique input values from a worksheet in the
 

Look at Data=Validation using he list option.

Since you can't refer to another sheet directly, you would need to create a
defined name (insert=Name=define) that refers to the list in the Road
Editor sheet. Then use that defined name as the source of your list for
data validation =List1 if list1 is the defined name.

This assumes the user only has unique entries in the list in Road Editor.

--
Regards,
Tom Ogilvy

"mathew" wrote in message
...
I need some help with a restricting a user to using a range of data that
they input first and then use again. Here is the situation: On the first
worksheet, the "Road Editor" and in one column "Node From" the user inputs
the names of "nodes." They can be any alphanumeric combination except they
cannot have any spaces and are case sensitive. Simple so far, but on a next
worksheet "Sale Editor" the user has to enter some of those exact, not all
of them only the relevant ones, node names into a column called "entry
Nodes." The data is then output to another program. If the user does not
input the exact node name the other program gives anomalous errors which are
very hard to track down. I have determined that I need to restrict the user
from only entering those unique node names that they created and input into
the first worksheet named "Road Editor" on the second worksheet called "Sale
Editor." I would like to have a pick box the user can choose from on the
"Sale Editor" worksheet. I have lost hundreds of hours try solutions, but
am total lost. Please help!

Creating pick box with unique input values from a worksheet in
 

Tom, thanks for the help! I used the Validation and the Countif as the function! Thanks again!

"Tom Ogilvy" wrote:

Look at Data=Validation using he list option.

Since you can't refer to another sheet directly, you would need to create a
defined name (insert=Name=define) that refers to the list in the Road
Editor sheet. Then use that defined name as the source of your list for
data validation =List1 if list1 is the defined name.

This assumes the user only has unique entries in the list in Road Editor.

--
Regards,
Tom Ogilvy

"mathew" wrote in message
...
I need some help with a restricting a user to using a range of data that
they input first and then use again. Here is the situation: On the first
worksheet, the "Road Editor" and in one column "Node From" the user inputs
the names of "nodes." They can be any alphanumeric combination except they
cannot have any spaces and are case sensitive. Simple so far, but on a next
worksheet "Sale Editor" the user has to enter some of those exact, not all
of them only the relevant ones, node names into a column called "entry
Nodes." The data is then output to another program. If the user does not
input the exact node name the other program gives anomalous errors which are
very hard to track down. I have determined that I need to restrict the user
from only entering those unique node names that they created and input into
the first worksheet named "Road Editor" on the second worksheet called "Sale
Editor." I would like to have a pick box the user can choose from on the
"Sale Editor" worksheet. I have lost hundreds of hours try solutions, but
am total lost. Please help!