Drop Down Cell

[jfern024]

I have created a drop down list. Options: Week1, Week2, Week3, Week4.


I want different data to populate when a different week is selected.


For example, I select Week1 and now data for week1 is shown below. I select data for week2 and data for week1 is gone but data for week2 is shown below.


Possible?

 

[vijay.vizzu]

Dear Jfern024


There are lot of ways to achieve this.


My using named ranges


Create named ranges as Week1,Week2,Week3,Week4 and put dates like 1-7-13 to 7-7-13 in week1, 8-7-13 to 14-7-13 in week2 and so on.


After you created range names, click data validation in one of the cells and select LIST and put names Week1,Week2..., and press ok


in another cells, click data validation and select list and in ref location type =INDIRECT(the cell address which u have created earlier).


Try this and revert.

 

[jfern024]

Step in the right direction.


What is the proper way to type the =INDIRECT formula?

 

[bobhc]

Good day jfern024


This link takes you to a "how to" page with videos and very good explanation of INDIRECT


http://www.contextures.com/xlDataVal01.html

 

[SirJB7]

Hi, jfern024!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about questions in general...


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


And about this question in particular...


Check this link:

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list


Regards!

 

[jeffreyweir]

jfern024 - THis might help too:

https://www.dropbox.com/s/8tfgn3t2l0m5lm5/Dynamic%20Dependent%20dropdowns%2020130716.xlsm


It shows how to implement cascading dropdowns that uses the non-volatile INDEX function, and also has some code in it to clear 'downstream' choices if upstream choices change. You can turn the code on or off, or even delete it entirely ...it's just there for informative purposes.


For more on the INDIRECT function being volatile - and what volatility means - check this link:

http://chandoo.org/forums/topic/what-is-indirect-function

 

[Smallman]

Hi Jfern


To add to some of the excellent responses based on limited information, you might want to include a little more information with your post?


I guess the first place to start would be where is your data? Is week1, week2 etc in the same sheet as the sheet you require a summary? Or perhaps the weeks are split in different sheets? If all the data is in on the one sheet the approach would be very different to if the data was all separated onto different sheets. You will need to be clear about how your data is structured before you can get an appropriate answer. Providing a link to your workbook (sample data if there is sensitive information) will be like gold dust for you as you take any ambiguity out of the post. If you upload your file or be more clear about how your data is structured I am pretty sure you will get a really swift and accurate answer.


Take care


Smallman