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.