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

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 sets cells.

For example, if 310UB40.4 is clicked from the drop down, excel should 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 from J3 to Q3, all the contents from row 25 should be copied to J4 to Q4 and copies down.

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

Thanks a lot..

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

You can do this with a drop down list of the values to look for tied
to a worksheet_change event to use datafilterautofllterfilter for
the valuecopy the visible cells to the destination cell

On Feb 9, 11:21*pm, rethish wrote:
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 sets
cells.

For example, if 310UB40.4 is clicked from the drop down, excel should
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 from
J3 to Q3, all the contents from row 25 should be copied to J4 to Q4 and
copies down.

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

Thanks a lot..

--
rethish