comparing matches

[saman110 via OfficeKB.com]

Does anyone know how to do this?

Master sheet:

A B C D
sam 1 10 100
sam 2 20 200
sam 3 30 300
sam 4 40 400
Tom 5 6 7

Compare sheet:

A B C D
Sam
Sam
Tom

Compare sheet after running the program:

A B C D
Sam 1 10 100
Sam 2 20 200
3 30 300
4 40 400
Tom 5 6 7

 

[Pete_UK]

Not a very good example - what's it meant to show? Apart from Sam's
name missing twice, the tables are identical.

Pete

 

[saman110 via OfficeKB.com]

It compares "sam" in master sheet with any matches in compare sheet and if it
finds one, it will copy and paste the corresponding cells into master sheet.
Now in compare sheet there are only 2 sams and in master sheet there are 4
sams, so it should find matches in 2 sams copy the other sams below them.

Thank you for your response.