I need to create a data table on one sheet and access it from another sheet.
On sheet one I would like to be able to create dropdown lists of one of the
columns on sheet two and when a choice is made then the row of that choice on
sheet 2 is filled in on sheet one.

Hope this is clear. Thanks for the help.

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 Thu, 23 Nov 2006 09:14:02 -0800, Dig wrote:

I need to create a data table on one sheet and access it from another sheet.
On sheet one I would like to be able to create dropdown lists of one of the
columns on sheet two and when a choice is made then the row of that choice on
sheet 2 is filled in on sheet one.

Hope this is clear. Thanks for the help.