LinkBack URL
About LinkBacks
How can I update a list (1-10) of items that are dependent on a data validation selection?
I am not looking to create two drop down lists, I would like cells A1 - A10 to populate depending on my drop down selection.
Thank you for your help!
How can I update a list (1-10) of items that are dependent on a data validation selection?
I am not looking to create two drop down lists, I would like cells A1 - A10 to populate depending on my drop down selection.
Thank you for your help!
Assuming your DD is in A1, you could use something as simple as...
A3=$A$1*10
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford,
I am not using numbers - just words.
for example: Depending on what is selected from the drop down: Lets say a State in the US.
The below cells will populate with the cities in that state.(which are located in a different tab and labeled lists)
Appreciate your help!
Thanks!
Upload a sample workbook
Data list example.xls
Ford,
Please see the attached. Thanks so much for your help !!
What version(s) of Excel does this have to work in?
The sample file is in the *.xls format but your profile says you're using Excel 2010.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I am using 2010.
I saved the file again, please see attached.
Thanks!
Data list example.xlsx
One way...
Enter this formula in B3 and copy down as needed:
=T(INDEX(LISTS!B$2:D$8,ROWS(B$3:B3),MATCH(B$1,LISTS!B$1:D$1,0)))
Note that in the sample file on the Lists sheet, cells B1 and C1 have trailing space characters.
In the dropdown list on the example sheet, Montana also has a trailing space character.
Tony Thank you so much this worked perfectly!!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks