Need immediate help!
I have two excel worksheets ; both consisting of simuliar data. Trying to
dicepher differences between the two worksheets , using sheet 2 as the master
sheet in which all data is to be referenced againist. Cannot seem derive the
answers I need. (* see example below). How would you approach the result
shown below.
Sheet 1
ComA Colm B Colm C Colm D Colm E Colum F
Area Item # Desc Length Width Height
001 333 Cookies 10 12 15
001 444 bread 12 12 12
001 555 cake 4 4 4
Sheet2
ComA Colm B Colm C Colm D Colm E Colum F
Area Item # Desc Length Width Height
002 333 Cookies 10 16 1
002 444 bread 12 2 17
002 555 cake 4 4 4

Results needed :
Sheet 3 - Match =
001 555 cake 4 4 4
002 555 cake 4 4 4

Sheet 4 -No Match
ComA Colm B Colm C Colm D Colm E Colum F
Area Item # Desc Length Width Height
001 333 Cookies 10 12 15
001 444 bread 12 12 12