PDA

View Full Version : Combining 2 files in one



fbo212
06-01-2007, 10:15 AM
I was told that there is a way to combine 2 files into one huge one using VLOOKUP. The first file (File A) contains a list of companies and banks and is organised catagorically by country. For example under the Country is a list of 5 or 6 entries. However in the second file (File B) each entry has the company name in column A and the country in Column B. Is there a way to bring the information in file A in the format of File B?

Any help on the subject would be appreciated.

:banghead:

mdmackillop
06-01-2007, 03:00 PM
Hi fbo,
Welcome to VBAX
Can you sanitise and post example files? Also a sample of your desired output. Use Manage attachments in the Go Advanced sections
Regards
MD