HI There,

I need your help with this issue:

sheet1

A B C
1 JHON ON1 2
2 FADI ON3 6
3 BRIAN ON4 5
4 MOHN ON9 2
5 ALEX ON6 7

sheet2

A B C
1 JHON ON1 2
2 BRIAN ON4 7
3 ALEX ON6 7
4 FADI ON3 8

I want sheet3 to be:
A B C
1 JHON ON1 2
2 FADI ON3 6
3 FADI ON3 8
4 BRIAN ON4 5
5 BRIAN ON4 7
6 MOHN ON9 2
7 ALEX ON6 7


I want macro to compare betwwen sheet1 and sheet2,
John & Alex were in both and same value in C col, copy to sheet three

Fadi & Brian were in both but different value in C col, copy row to sheet3 and fill the row copied from sheet2 with "green for example"

Mohn was only in sheet1, copy to sheet3

Sorry being my question is long, but really I need help

Thanks in advance

Ziyadh

On Feb 4, 1:01*pm, Ziyadh wrote:
HI There,

I need your help with this issue:

sheet1

* * * * A * * * B * * * C
1 * * * JHON * *ON1 * * 2
2 * * * FADI * *ON3 * * 6
3 * * * BRIAN * ON4 * * 5
4 * * * MOHN * *ON9 * * 2
5 * * * ALEX * *ON6 * * 7

sheet2

* * * * A * * * B * * * C
1 * * * JHON * *ON1 * * 2
2 * * * BRIAN * ON4 * * 7
3 * * * ALEX * *ON6 * * 7
4 * * * FADI * *ON3 * * 8

I want sheet3 to be:
A * * * B * * * C
1 * * * JHON * *ON1 * * 2
2 * * * FADI * *ON3 * * 6
3 * * * FADI * *ON3 * * 8
4 * * * BRIAN * ON4 * * 5
5 * * * BRIAN * ON4 * * 7
6 * * * MOHN * *ON9 * * 2
7 * * * ALEX * *ON6 * * 7

I want macro to compare betwwen sheet1 and sheet2,
John & Alex were in both and same value *in C col, copy to sheet three

Fadi & Brian were in both but different value in C col, copy row to
sheet3 and fill the row copied from sheet2 with "green for example"

Mohn was only in sheet1, copy to sheet3

Sorry being my question is long, but really I need help

Thanks in advance

Ziyadh

--
Ziyadh

Send this msg and your file to dguillett1 @gmail.com