-
Combining 2 files in one
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.
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules