VBA find string and copy part of row

[cazdealer]

Hi,

I need help with a vba procedure.

I have 2 excel files. DATA.xlsm and RESULTS.xlsm.

in the sheet1 of results.xlsm, I have strings from A1 to A100... C, BAC, GS, MS, SPY, IBM... etc.

in the sheet1 of DATA.xlsm, I have the same kind of strings from A1 to A10000.


I would like to create a vba procedure that will look in all the cells of column A from data.xlsm to find the exact match of the string in A1 from results.xlsm. When it does find the same string, it will copies the row from A to D of data.xlsm into cell M1 of results.xlsm.
then, do the same for A2, A3... etc to A100.

if it doesnt find a matching string, I would like that it copies nothing and continue the loop.

 

[wigi]

Hello

You do not need VBA code here, a usual VLOOKUP function will be enough.

You wrap an IF test around it to see if the string occurs in the DATA sheet.