I need help in how to do this:
Once I key in a Lot number at column A, column B will auto import the text
file based on the lot number in cell A1 (or the nearest match) from a folder
in worksheet B.
How to program it? Thanks.