Input 2 files and create 3rd file

14 views
Skip to first unread message

excelnew

unread,
Mar 20, 2016, 3:46:02 PM3/20/16
to excel vba

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.
Zip-Input.xlsx
Emp-Input.xlsx
Zip-Emp-Output.xlsx

Vaibhav Joshi

unread,
Apr 12, 2016, 12:34:50 PM4/12/16
to excel vba
is it resolved?

Cheers!!
Reply all
Reply to author
Forward
0 new messages