| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve data from Drop Down List
Hi there,
I tried to find a solution to my problem but couldn't find exactly what I was looking for so I thought I would post it. :) What I would like to do is have a user pick an area from a drop down list (say in cell A1), and then, once the item has been selected, have the list of programs for that area appear from A5 to A'x' depending on how many programs there are for that area. Is this possible?? I have a separate tab set up with a named ranges for AREA and PROGRAM and I have my drop down menu working fine with the data validation for AREA. Basically my lists look something like this AREA List PROGRAM List AREA 1 AREA 1 PROGRAM 1 AREA 2 AREA 1 PROGRAM 2 AREA 3 AREA 1 PROGRAM 3 AREA 2 PROGRAM 1 AREA 2 PROGRAM 2 AREA 3 PROGRAM 1 If someone could help me out, that would be great! Thanks in advance!! -- TT |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieve data from Drop Down List
Here's a sample file.
sample.xls 13.5kb http://cjoint.com/?dyeX1ikJbl You have to copy the formula to enough cells that it covers the max number of programs for any area. In your sample data Area 1 has the most programs, 3, so, you'd have to copy the formula to at least 3 cells. In the sample file I've copied the formula to 5 cells. Biff "TT" wrote in message ... Hi there, I tried to find a solution to my problem but couldn't find exactly what I was looking for so I thought I would post it. :) What I would like to do is have a user pick an area from a drop down list (say in cell A1), and then, once the item has been selected, have the list of programs for that area appear from A5 to A'x' depending on how many programs there are for that area. Is this possible?? I have a separate tab set up with a named ranges for AREA and PROGRAM and I have my drop down menu working fine with the data validation for AREA. Basically my lists look something like this AREA List PROGRAM List AREA 1 AREA 1 PROGRAM 1 AREA 2 AREA 1 PROGRAM 2 AREA 3 AREA 1 PROGRAM 3 AREA 2 PROGRAM 1 AREA 2 PROGRAM 2 AREA 3 PROGRAM 1 If someone could help me out, that would be great! Thanks in advance!! -- TT |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieve data from Drop Down List
Thank you very much!
This does EXACTLY what I was looking for! -- TT "T. Valko" wrote: Here's a sample file. sample.xls 13.5kb http://cjoint.com/?dyeX1ikJbl You have to copy the formula to enough cells that it covers the max number of programs for any area. In your sample data Area 1 has the most programs, 3, so, you'd have to copy the formula to at least 3 cells. In the sample file I've copied the formula to 5 cells. Biff "TT" wrote in message ... Hi there, I tried to find a solution to my problem but couldn't find exactly what I was looking for so I thought I would post it. :) What I would like to do is have a user pick an area from a drop down list (say in cell A1), and then, once the item has been selected, have the list of programs for that area appear from A5 to A'x' depending on how many programs there are for that area. Is this possible?? I have a separate tab set up with a named ranges for AREA and PROGRAM and I have my drop down menu working fine with the data validation for AREA. Basically my lists look something like this AREA List PROGRAM List AREA 1 AREA 1 PROGRAM 1 AREA 2 AREA 1 PROGRAM 2 AREA 3 AREA 1 PROGRAM 3 AREA 2 PROGRAM 1 AREA 2 PROGRAM 2 AREA 3 PROGRAM 1 If someone could help me out, that would be great! Thanks in advance!! -- TT |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieve data from Drop Down List
You're welcome. Thanks for the feedback!
Biff "TT" wrote in message ... Thank you very much! This does EXACTLY what I was looking for! -- TT "T. Valko" wrote: Here's a sample file. sample.xls 13.5kb http://cjoint.com/?dyeX1ikJbl You have to copy the formula to enough cells that it covers the max number of programs for any area. In your sample data Area 1 has the most programs, 3, so, you'd have to copy the formula to at least 3 cells. In the sample file I've copied the formula to 5 cells. Biff "TT" wrote in message ... Hi there, I tried to find a solution to my problem but couldn't find exactly what I was looking for so I thought I would post it. :) What I would like to do is have a user pick an area from a drop down list (say in cell A1), and then, once the item has been selected, have the list of programs for that area appear from A5 to A'x' depending on how many programs there are for that area. Is this possible?? I have a separate tab set up with a named ranges for AREA and PROGRAM and I have my drop down menu working fine with the data validation for AREA. Basically my lists look something like this AREA List PROGRAM List AREA 1 AREA 1 PROGRAM 1 AREA 2 AREA 1 PROGRAM 2 AREA 3 AREA 1 PROGRAM 3 AREA 2 PROGRAM 1 AREA 2 PROGRAM 2 AREA 3 PROGRAM 1 If someone could help me out, that would be great! Thanks in advance!! -- TT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| drop down list that changes the data of 3 other cells | New Users to Excel | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Linear Mode
