Compare 2 worksheets to get unique data

newbie - Jan 16, 2010 at 02:25 AM
 Blocked Profile - Jan 16, 2010 at 02:38 AM

Im a newbie in VBA. I've been reading basic tutorials on VBA but I still can't apply the basics to the actual project, which involves more complexed coding. I have two worksheets (WS1 & WS2) which both lists the name of students. The names listed in WS1 are not consistent with the names listed in WS2. I would want to be able to compare both worksheets. I want to extract only the names which appear in both worksheets and paste them in another worksheet (WS3) using macro (which runs automatically once WS3 opens). Please help!! Thanks !!:)

something that looks like this :
Name Name Name
lala lala lala
lala2 lala3 lala3

1 response

Blocked Profile
Jan 16, 2010 at 02:38 AM
Dear Sir,

Please have the solution for the task that you are wishing to

perform from the below Kioskea FAQ article:

How to compare 2 excel sheet and combine uniq data?