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?

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?

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?

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

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

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

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