hi--i'm trying to come up with either a function or a macro, & would
appreciate any input!

i have 2 worksheets, one with a list of production outputs for 12 production
machines. the 2nd worksheet is the crew that ran the lines. in the outputs,
each line has different values for each product code. (code, description, and
then specs.)

i'd like to set it up so that on the crew worksheet, a dropdown list will
provide the product code in the leftmost column. (that part i've got figured
out).

once the product code is selected, i'd like excel to lookup the row of data
related to that product code in the "outputs", and copy the entire row to the
"crew" worksheet. there are 21 columns to be copies, not including the 1st
column with the product code. i can't use a vlookup because the product codes
in the outputs sheet are not in numerical order (and can't be rearranged,
because there are several macros linked to other worksheets); i tried an
index/match formula but it only returns one cell value at a time. there are
also occasionally blank lines within each section's product codes.

any function/macro suggestions would be very welcome!
thanks
steph
--
steph