stevep2k21uk
New Member
- Joined
- Mar 22, 2021
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
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 :
does this make sense?
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 :
- run the macro.
- it imports the file mentioned above into sheet2 from a specified location.
- then compares "sheet2 column A" with "sheet1 column B".
- then copy the cell adjacent (sheet2 column B)
- 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 |