I am attaching my excel spreadsheet with this post:
In sheet1: I have these records: (Company Records)
In sheet 2: I have these records: (All Records)
In sheet 2 i have all the contacts that includes personal contacts, company contacts etc plus in few records there is no company name, address etc
(a)Now in sheet 3 i want those records (with complete row i.e. all fields) from sheet 2 that matches with records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
(b) In addition to that the records which are in sheet 2, i am not sure if they are correct or not,
so if any row (from sheet 2) matches with row(in sheet 1)[on bases of 3 fields that i mentioned above] i want Address, website and JobTitle (in resultant sheet 3) to be updated according to sheet 1
How to do that ? please guide me....as i have 10,000 records and manually doing each one is not possible....
i have mentioned my problem/issue on the excel sheet also...
I would really appreciate if anyone could help me with this....
Bookmarks