I was wondering if there is an easier way to add 2 seperate dropdown list of names instead of just putting them on the main sheet?...
I was wondering if there is an easier way to add 2 seperate dropdown list of names instead of just putting them on the main sheet?...
Yes.
Just use data validation and put the range on another sheet. (see attached)
----
edit
you can also hide the sheet containing the menu (names) and you can name the range...make the range grow to match any size list w/o editing ... etc. there are many examples of ways to make 'data validation' work.
The attached example is a simple place to start.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks