Hi
i have two excel sheets in the same workbook. Sheet1& sheet2. sheet1 is compared against sheet2, where "Sheet1" is the base sheet. some records are different and most important they are not in the same cells or in same order as sheet1. The Cells are compared using a column say "Name" in sheet1 against name in sheet2. If sheet2 has the same data in each cell against that column" Name" Then the result should be in "true"or "False" format in sheet3. If "true" then highlight it with green colour and if "false" orange colour. This "true" or "false" should be in the same order of data which is in sheet1. I'l show a simple example of what i want:

Sheet1
1.Name Age fav-No
2.mary 14 1
3.ann 15 3
4.mike 13 5
5.jude 15 3
6.jim 16 2

Sheet2
1.Name Age fav-No
2.tom 14 1
3.mike 13 5
4.ann 15 3
5.jim 16 2

Sheet3
1.Name Age fav-No
2.false true true//since"mary" is not in "sheet2"
3.true true true //since "ann" is in 3rd row in "sheet1" it is placed in 3rd row in "sheet3"
4.true true true//since "mike" is in 4th row in "sheet1"
5. //since "jude" is not present in "sheet2" leave it blank space in "sheet3"
6. true true true//since "jim" is in "6th" row in "sheet1"


please help me in this and i have no idea about Macros...gayunana01

Posts: 1
Joined: Jul 9, 2012
Excel Version: 2007