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