Hello there. I'm having trouble with dealing two worksheets, hopefully someone can help me with this.
The problem is that i have two worksheets with customers' information. List1 contains all 2000 customers for our company with Name(Column A), Address(Column B), Tel.(Column C), Email(Column D), Privateemail(Column E), Customercatogory(Column F) and a lot of other information for every customer. However, some cells, except in the Name(column A), are empty. For example, you can find a customer named Tom(A5) with only Address(B5) and Privateemail(E5), but no data in Tel.(C5) and Email(D5). In List2, there are 300 customers with only four columns of Name(Column A), address(Column B), Tel.(Column C), and Email(Column D). Those 300 customers in List2 already exist in the List1, but they may contains information that is missing in List1, such as Tom's Tel. and Email.
Now what i want to do is to fill in the empty cells in List1 with help of the complementary information from List2. I plan to Vlookup all 300 names in the List1 and check if a certain customer's empty information in List1 can be found in List2. If it does, let's say List2 contains data about Tom's Email and address, I would like to copy these data from List2 to C5(Tel.) and D5(Email) in the List1. Is that possible using Vlookup function in combination with some others since i'm not experienced in using VBA.
To sum up, it is basically to match two lists and see if cells in List2 contains info that is missing in List1. Hoepfully I have explained the problem clearly...Any advice would be appreciated!
Bookmarks