Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
I need to be able to create a drop down list (actually i already know how to
do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
Assuming you are using Data Validation list.
Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
ok. i think that i am missing something here. on sheet 2 i have 3 columns
of data. how can i get certain columns from sheet 2 to certain columns on sheet 1? i was able to do every thing else, although there is no data showing up where i need it to be. "Gord Dibben" wrote: Assuming you are using Data Validation list. Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
Appears I may have misread your original post.
Do you want to use a DV dropdown to enter an item in a cell then have the data brought over from Sheet2 into adjacent cells? e.g. enter ID number in sheet1 A1 and have Sheet2 A1:C1 brought over into B1:D1 Data Validation for the drop-downs and VLOOKUP for the filling-in part. 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 Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 11:31:01 -0800, Jose TNG wrote: ok. i think that i am missing something here. on sheet 2 i have 3 columns of data. how can i get certain columns from sheet 2 to certain columns on sheet 1? i was able to do every thing else, although there is no data showing up where i need it to be. "Gord Dibben" wrote: Assuming you are using Data Validation list. Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
ok. let me give you an example of what i have done before.
in the past when i have needed to create a drop down list on the same sheet i go to Data, validation. once there i select list, ignore blank cells, then on the same sheet i highlight the data that i want to be in the drop down list, then click on ok. once done i go the cell and make sure that there is a list with the data that i need. with that said, in this case i have data on sheet2, but the main sheet is sheet1. the columns with data on sheet2 i need to be in the drop down list on sheet1 in certain cells. Is this possible? "Gord Dibben" wrote: Appears I may have misread your original post. Do you want to use a DV dropdown to enter an item in a cell then have the data brought over from Sheet2 into adjacent cells? e.g. enter ID number in sheet1 A1 and have Sheet2 A1:C1 brought over into B1:D1 Data Validation for the drop-downs and VLOOKUP for the filling-in part. 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 Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 11:31:01 -0800, Jose TNG wrote: ok. i think that i am missing something here. on sheet 2 i have 3 columns of data. how can i get certain columns from sheet 2 to certain columns on sheet 1? i was able to do every thing else, although there is no data showing up where i need it to be. "Gord Dibben" wrote: Assuming you are using Data Validation list. Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
Alright, I got this thing to work correctly, I followed the link below and
helped me. Thanks! "Gord Dibben" wrote: Appears I may have misread your original post. Do you want to use a DV dropdown to enter an item in a cell then have the data brought over from Sheet2 into adjacent cells? e.g. enter ID number in sheet1 A1 and have Sheet2 A1:C1 brought over into B1:D1 Data Validation for the drop-downs and VLOOKUP for the filling-in part. 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 Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 11:31:01 -0800, Jose TNG wrote: ok. i think that i am missing something here. on sheet 2 i have 3 columns of data. how can i get certain columns from sheet 2 to certain columns on sheet 1? i was able to do every thing else, although there is no data showing up where i need it to be. "Gord Dibben" wrote: Assuming you are using Data Validation list. Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? Gord Dibben MS Excel MVP |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop down lists
You can have data from only one column in a list.
In order to use that list on sheet1 you have to give it a name as I pointed out in my first post. Gord On Wed, 6 Dec 2006 13:41:00 -0800, Jose TNG wrote: ok. let me give you an example of what i have done before. in the past when i have needed to create a drop down list on the same sheet i go to Data, validation. once there i select list, ignore blank cells, then on the same sheet i highlight the data that i want to be in the drop down list, then click on ok. once done i go the cell and make sure that there is a list with the data that i need. with that said, in this case i have data on sheet2, but the main sheet is sheet1. the columns with data on sheet2 i need to be in the drop down list on sheet1 in certain cells. Is this possible? "Gord Dibben" wrote: Appears I may have misread your original post. Do you want to use a DV dropdown to enter an item in a cell then have the data brought over from Sheet2 into adjacent cells? e.g. enter ID number in sheet1 A1 and have Sheet2 A1:C1 brought over into B1:D1 Data Validation for the drop-downs and VLOOKUP for the filling-in part. 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 Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 11:31:01 -0800, Jose TNG wrote: ok. i think that i am missing something here. on sheet 2 i have 3 columns of data. how can i get certain columns from sheet 2 to certain columns on sheet 1? i was able to do every thing else, although there is no data showing up where i need it to be. "Gord Dibben" wrote: Assuming you are using Data Validation list. Name the list range on sheet2 by selecting the range and InsertNameDefine. Nmae it "mylist"(no quotes) Then on sheet1 for DV source enter =mylist Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 09:22:00 -0800, Jose TNG <Jose wrote: I need to be able to create a drop down list (actually i already know how to do this)on sheet 1. i have the data that i will be using on the same workbook but different sheet (#2). how can i go about doing this? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists | New Users to Excel | |||
Setting up conditional drop down lists in Excel 2003? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
Drop Down Lists - Not allowing other contents to be put in same ce | Excel Worksheet Functions |