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.