Hi all,

I'm hoping someone can help. I have a sheet with a column where the
user selects a product from a drop down list. I want to be able to
match the selected value with a table on a seperate sheet and copy over
the matching row. The table has the product name, size, colors, weight,
etc. I need the values and the formulas of the row copied over as well.

Hope that makes sense.

T.