Hi There,
I have an issue and i would say my Excel skills are average
I am looking to merge 2 worksheets together but only merge if certain columns match
EXAMPLE:
Worksheet 1 - has the following columns
Date Sold
Client Name
Post Code
Date of Birth
Life Insurance Provider
Estimated Commission
Authorised Seller
Opener
Form Agreeement Signed
Worksheet 2 - has the following columns
Date Paid
Client Name
Post Code
Date of Birth
Life Insurance Provider
Commission
Authorised Seller
Opener
I am looking on a 3rd worksheet for the first sheet to be copied completely and then from the 2nd sheet i am looking for Date Paid, Commission to be copied across into the correct row based on matching 2 out of 3 criteria
The Criteria is
Client Name
Post Code
Date of Birth
I have looked all over the internet for this and couldn't see any answer
Your speedy response is highly appreciated
Thanks
I have an issue and i would say my Excel skills are average
I am looking to merge 2 worksheets together but only merge if certain columns match
EXAMPLE:
Worksheet 1 - has the following columns
Date Sold
Client Name
Post Code
Date of Birth
Life Insurance Provider
Estimated Commission
Authorised Seller
Opener
Form Agreeement Signed
Worksheet 2 - has the following columns
Date Paid
Client Name
Post Code
Date of Birth
Life Insurance Provider
Commission
Authorised Seller
Opener
I am looking on a 3rd worksheet for the first sheet to be copied completely and then from the 2nd sheet i am looking for Date Paid, Commission to be copied across into the correct row based on matching 2 out of 3 criteria
The Criteria is
Client Name
Post Code
Date of Birth
I have looked all over the internet for this and couldn't see any answer
Your speedy response is highly appreciated
Thanks