hi all
is it possible to set up something so the user of the spreadsheet can only complete a second data validation drop down option if the first has been selected?
Hopefully makes sense!
Thanks
hi all
is it possible to set up something so the user of the spreadsheet can only complete a second data validation drop down option if the first has been selected?
Hopefully makes sense!
Thanks
Sort of.
Assume cells A1 and B1 contain drop down lists.
As the source for the drop down in B1 use something like this:
=IF($A$1<>"",List,#N/A)
Where List is a named range.
However, if the selection in cell A1 is cleared/deleted the previous selection in cell B1 is still there.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I think you are looking for this.
Create multiple linked dropdown list in excel
http://helpdeskgeek.com/office-tips/...ists-in-excel/
http://thefinch.wordpress.com/2008/0...datavalidatie/
http://www.contextures.com/xlDataVal02.html
http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
thanks for the response.
all i really need is it set up so column a is completed and then allows column b to be completed. the responses will not change.
Tony's response should work for you.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks