Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up an If-Then Statement that will pull from a valdiated li
Hi! Can anyone help me?
I have Excel 2003. I have created several validated lists. Now, I want to be able to tie these together. For example, in the first cell, my drop down list choices are A, B, and C. I would like the second cell to bring up a drop down from a validated list that I have created, and the list that is shown is dependent on the original choices in my first cell (A,B, or C). So for example, if in my first cell I chose 'Car Manufacturer' from my validated drop down list, I want the second cell to show drop down choices from the list I created that includes Acura, Ford, etc. BUT, if I choose 'Motorcycle Manufacturer' in my first cell, I want the second cell to show choices from another list (Honda, Kawasaki), etc. Does this make sense? How can I do this? Thank you for your help! Angie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up an If-Then Statement that will pull from a valdiated li
See this:
http://contextures.com/xlDataVal02.html Biff "govols865" wrote in message ... Hi! Can anyone help me? I have Excel 2003. I have created several validated lists. Now, I want to be able to tie these together. For example, in the first cell, my drop down list choices are A, B, and C. I would like the second cell to bring up a drop down from a validated list that I have created, and the list that is shown is dependent on the original choices in my first cell (A,B, or C). So for example, if in my first cell I chose 'Car Manufacturer' from my validated drop down list, I want the second cell to show drop down choices from the list I created that includes Acura, Ford, etc. BUT, if I choose 'Motorcycle Manufacturer' in my first cell, I want the second cell to show choices from another list (Honda, Kawasaki), etc. Does this make sense? How can I do this? Thank you for your help! Angie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up an If-Then Statement that will pull from a valdiate
Thank you!!
I was actually looking around while I waited for a reply, and found that site in another answered post. Great website, great instructions.. I am going through them now. If I need more help, I will post again. I appreciate your quick answer! "T. Valko" wrote: See this: http://contextures.com/xlDataVal02.html Biff "govols865" wrote in message ... Hi! Can anyone help me? I have Excel 2003. I have created several validated lists. Now, I want to be able to tie these together. For example, in the first cell, my drop down list choices are A, B, and C. I would like the second cell to bring up a drop down from a validated list that I have created, and the list that is shown is dependent on the original choices in my first cell (A,B, or C). So for example, if in my first cell I chose 'Car Manufacturer' from my validated drop down list, I want the second cell to show drop down choices from the list I created that includes Acura, Ford, etc. BUT, if I choose 'Motorcycle Manufacturer' in my first cell, I want the second cell to show choices from another list (Honda, Kawasaki), etc. Does this make sense? How can I do this? Thank you for your help! Angie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal macro file will not pull up when excel is started | Setting up and Configuration of Excel | |||
How can I pull data from multiple user workbooks into one? | Excel Discussion (Misc queries) | |||
Not all data in AutoFilter pull down | Excel Worksheet Functions | |||
Why does AutoFilter not show all the data in the pull down? | Excel Discussion (Misc queries) | |||
I need assistance setting up a "IF" statement | Excel Worksheet Functions |