Locate & copy just two cells!

[Daghs]

Hi

I have two files "Data.csv" & "Output.csv".

In data file just in column "B" I'd like to locate the word "JACK" (remember it would be just once in column "B" & I want to find that).
Now where it's located this cell & in the same row cell of column "A" (just these two cells).
I want to copy and paste it to the Output file's "A2" cell, one thing where I want to use this macro they still use excel 2010 so anyone could suggest any macro it'd be a great help.

Thanks

 

[Daghs]

Hi,
You just got me a relief from a headache,
I really mean it thanks!
I'm sorry but I have to ask one thing more,
Here we are finding in column "B" and in the same row copying from column"A" as well
What if instead of column "A" we got column"D"
What would be the change in the code!
Thanks again for the help what nobody else did you did, thanks a lot!

 

[Alex Blakenburg]

No problem, happy to help.
Just change the one line that does cells in columns A & B to 2 lines, see below.
Let me know if you need help with it.

mainSht.Range("B2").Value = csvSht.Range("B" & csvRow).Value
mainSht.Range("D2").Value = csvSht.Range("D" & csvRow).Value