comparing matches

  • Thread starter saman110 via OfficeKB.com
  • Start date
S

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
 
P

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top