I'm trying to create a form that draws information from a table on a
seperate spreadsheet. This is an order form and the table carries the
product information....see below. What I need
is when the user selects a product and color, the adjacent cells in the
product table, with values and formulas, are copied to the form.

Item Color Quantity Weight Units/row
Paleo Beige 123 23.5lbs 42
Bergerac Grey 123 32 lbs 38

So if I have a drop down list on another sheet that chooses Paleo, then

the adjacent formulas and cells from the table would be copied over.


Maybe I should be doing this through a macro tied to a button.


Thanks again for your help.