Macro help for duplicates on two workbooks

**vanthaman** · 05-27-2011, 01:14 AM

I have first and last names on two different columns for both workbooks. Each individual has a different username which is also organized in another column but in only one of those two workbooks. Workbook 1 does not have the usernames. Workbook 2 has the usernames but also has extra individuals. Is there a macro that can compare the individuals and match the correct username from Workbook 2 to the individuals in Workbook 1. If that makes sense. Thanks

**pr4t3ek** · 05-27-2011, 02:01 AM

concatenate the names on both workbooks then do a vlookup? you won't need a macro for this i highly doubt.

Can you upload your two workbooks or sample data so i can do this for you?

**vanthaman** · 05-27-2011, 02:07 AM

I uploaded the workbooks. hope this helps.

**pr4t3ek** · 05-27-2011, 02:14 AM

see what i've done in column g and h

**vanthaman** · 05-27-2011, 05:02 PM

thank you! exactly what I needed

**yogeshwarv** · 10-30-2011, 03:24 AM

Hi, I have a query if you can please help me.

How can we check duplicate record from an open workbook to another closed workbook through VBA

I have two workbooks one is employee and another is employee database.xls.

I want if I save data of employee workbook through Macro in Employee Database it should check if the employee code already exist if found return back or pass the entry to Employee Database.

Can anybody help me on this please.

**ConneXionLost** · 10-30-2011, 03:40 AM

yogeshwarv,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.