Validating drop down list dating curves tango

26-Feb-2015 05:43

I would be most willing to send you this small spreadsheet example for you to look at if you wish.Thanks Larry Before I was upgraded to Excel 2010 I typed numbers in my drop down box because it’s faster than stopping and looking down the list.So, Click on drop down arrow, Click on Hallway 1, Click on drop down arrow, Click on Room # 125. I am doing this for a High School for Substitute Teachers. Thanks Larry At first I dismissed this as not possible, but the more I thought about it the more likely it’s solution seemed within reach.It will require some VBA code, but I believe it can be done.I see all kinds of dependent drop down lists where you select an item and then go to the next column and select another item.In my case I would like to create a dependent drop down list where you select a Hallway (example: Hallway 1) in say cell A1, after selecting Hallway 1, I would then click on cell a1 drop down list again and have it show me a list of all the Room Numbers in Hallway 1 being the final result.

This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.

Video tutorials and step by step instructions are below In this tutorial, you'll see how to create a drop down list of choices in a cell, like the list of employee names shown below.

To create a drop down list in Excel 2010, you can name a list of items, based on a named Excel table.

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell.

Here is a short how-to guide to get you started on data validation in excel.

This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts. Video tutorials and step by step instructions are below In this tutorial, you'll see how to create a drop down list of choices in a cell, like the list of employee names shown below.To create a drop down list in Excel 2010, you can name a list of items, based on a named Excel table.Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. Here is a short how-to guide to get you started on data validation in excel. Is the default selection a single value or a list you pick from?