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