I have 4 different files that I want to merge into one.
The data set is gigantic so I wanted to create a macro to
do the dirty work for me. The three files each of keys.
1 file is 1 key the 2nd file is the 2nd key and the 3rd
file is the one that matches the first and second keys to
give me a name. Now I want to get the information from
all of these onto one file. So basically im asking is how
to go about matching them up. I need them to be matched
and then the corresponding row be added into the already
existing row in the target file. THANK YOU!!!