Hello everyone,

I need to create an automated macro that will:

1. Open a workbook (easy).

2. Then prompt to import a text file from the selected
sheet in the workbook (easy).

--
This is the tricky part:

3. The values in the imported file need to be compared to some values
in another base worksheet based on ID numbers.

4. If the values match then another field from the "imported" file is
written
to the base worksheet.

--

** Any advice will be greatly appreciated. I need to start in the right
direction then move forward. I'm assuming this will involve several
modules.

--
Thanks,
Himansu