Macro to search a text in a cell and copy the row to another set of cell

[rethish]

HI All,

There is a drop down which when i click on a text in the drop down list
excel should search for the text in a specific column, if found matched
copy the contents of the row where the text was found into another set
cells.

For example, if 310UB40.4 is clicked from the drop down, excel shoul
search for "310UB40.4" in column B. Since 310UB540.4 is found in row 8
25, 52 etc in column B, all the contents in row 8 should be copied fro
J3 to Q3, all the contents from row 25 should be copied to J4 to Q4 an
copies down.

Please help. Been bogged down with this for a while now.

Thanks a lot.

 

[Don Guillett]

You can do this with a drop down list of the values to look for tied
to a worksheet_change event to use data>filter>autofllter>filter for
the value>copy the visible cells to the destination cell