Hi,

I have a workbook that contains 2 worksheets, I need a macro that will search one worksheet and pull the data across.

Sheet 1 will be the main sheet, and sheet 2 will contain all the data.

I want to be able to type a Code in cell F13 on sheet one and the macro will automatically run and search sheet 2 for whatever was typed in cell F13.

Once it has found whatever was in F13 I want it to pull some of the data from the row that it was found to a cell in the other worksheet, for example if it finds something in row 13 i want it to take the data from say the D column in row 13 across to a cell in sheet1. Here is what I want:


Sheet 2 ----> Sheet 1
B column ----> F15
C column ----> F24
D column ----> F17
E column ----> F18
F column ----> F19
G column ----> F20
H column ----> F25

I hope this is understandable?