Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
Hi
I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
Absolutely! Take a look at these:
http://www.contextures.com/xlDataVal13.html http://www.contextures.com/xlDataVal01.html Regards, Ryan-- -- RyGuy "DebbieV" wrote: Hi I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 8 Jan 2008 13:19:42 -0800 (PST), DebbieV wrote: Hi I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
I need to do something similar but I need to have the same cell populated.
Using the same example below: Grapes 5 kgs Beans 7 kgs Pear 8 kgs In Worksheet 2 in cell A2 I would like to be able to choose Beans from the drop down and have 7 kgs appear in A2. Beans will not appear in Worksheet 2 anywhere. I could not find a way to combine the drop down and VLOOKUP in one cell. Thanks! "Gord Dibben" wrote: VLOOKUP formulas will pull the data to appropriate cells. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 8 Jan 2008 13:19:42 -0800 (PST), DebbieV wrote: Hi I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
I know of no way to achieve your goal of having all in one cell.
Browse through Debra Dalgleish's site on DV and see if something strikes your fancy, but I see nothing to return a value in the same cell as a dropdown. http://www.contextures.on.ca/tiptech.html Gord On Fri, 18 Jan 2008 08:07:02 -0800, Marnie wrote: I need to do something similar but I need to have the same cell populated. Using the same example below: Grapes 5 kgs Beans 7 kgs Pear 8 kgs In Worksheet 2 in cell A2 I would like to be able to choose Beans from the drop down and have 7 kgs appear in A2. Beans will not appear in Worksheet 2 anywhere. I could not find a way to combine the drop down and VLOOKUP in one cell. Thanks! "Gord Dibben" wrote: VLOOKUP formulas will pull the data to appropriate cells. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 8 Jan 2008 13:19:42 -0800 (PST), DebbieV wrote: Hi I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting from drop down list enters multiple cell data
Thank you for responding. I will find an alternate way to do what I need to
do. Thanks Marni "Gord Dibben" wrote: I know of no way to achieve your goal of having all in one cell. Browse through Debra Dalgleish's site on DV and see if something strikes your fancy, but I see nothing to return a value in the same cell as a dropdown. http://www.contextures.on.ca/tiptech.html Gord On Fri, 18 Jan 2008 08:07:02 -0800, Marnie wrote: I need to do something similar but I need to have the same cell populated. Using the same example below: Grapes 5 kgs Beans 7 kgs Pear 8 kgs In Worksheet 2 in cell A2 I would like to be able to choose Beans from the drop down and have 7 kgs appear in A2. Beans will not appear in Worksheet 2 anywhere. I could not find a way to combine the drop down and VLOOKUP in one cell. Thanks! "Gord Dibben" wrote: VLOOKUP formulas will pull the data to appropriate cells. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 8 Jan 2008 13:19:42 -0800 (PST), DebbieV wrote: Hi I was wondering if it was possible to have a drop down list and when a entry is selected it automatically populates other cells with the correct information (bit like an IF) Example: This is my data validation list for the drop downs in Worksheet 1. A B C 1 Grapes Fruit 5 kgs 2 Beans Veges 7 kgs 3 Pear 4 Cauliflower In my Worksheet 2 I would like to be able to select Beans from the entries from Col A in cell reference B7 and when that is selected in Veges will appear in C7 and 7 kgs in D7. Any ideas? I use both 2003 & 2007 (in case there is any difference in what functions are available) cheers Debbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple items from drop-down list | Excel Discussion (Misc queries) | |||
selecting multiple items in an excel drop down list | Excel Discussion (Misc queries) | |||
Selecting multiple items from a drop down list | Excel Discussion (Misc queries) | |||
Jump to next cell after selecting from drop down list | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions |