I have a challenges where I have two input files
1. 1. Emp-Input.xlsx 2. Zip-Input file.xlsx
I am creating a 3rd workbook (Emp-Zip-Output.xlsx) file taking data from the two input files.The original file contains thousands of records. Can you suggest a VBA code to automate the process?
Zip-Emp-OUTPUT
File column explanations
ZIP (Column A) : These values comes from “zip-input” file.
TERRITORY (Column B) : These
values comes from “zip-input” file.
FIRST NAME (Column C) : These values comes from “emp-input” file that match Territory (Column B) against TERRITORY (Column B) of “Output” file.
LAST NAME (Column D) : These values comes from “emp-input” file that match Territory (Column B) against TERRITORY (Column B) of “Output” file.
Region(Column E) : These values comes from “emp-input” file that match Territory (Column B) against TERRITORY (Column B) of “Output” file.