comparing matches
 

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

--
Message posted via http://www.officekb.com

comparing matches
 

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

Pete

On Apr 23, 6:33*pm, "saman110 via OfficeKB.com" <u35670@uwe wrote:
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

--
Message posted viahttp://www.officekb.com

comparing matches
 

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.

saman110 wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1