macro to compare 2 cells and copy adjacent cell

[stevep2k21uk]

hi,
something i need help with myself, i have an inventory scanner that scans a part then update quantity, it saves as an comma separated txt file called InvMgr.txt.
im wanting to :

1. run the macro.
2. it imports the file mentioned above into sheet2 from a specified location.
3. then compares "sheet2 column A" with "sheet1 column B".
4. then copy the cell adjacent (sheet2 column B)
5. then paste to the cell on sheet1 column M. see below:

SHEET1

A

B

C

D

E

F

G

H

I

J

K

L

M

1

000005 - COMPARE WITH SHEET2 COL A

6 PASTE FROM SHEET 2 COL B

2

SHEET2​
A​	B​
000005	6 - COPY THIS CELL

does this make sense?

 

[stevep2k21uk]

edit.

Also to add i need to then select the whole of sheet1 and save just that as a .csv file for import onto my website.