Compare Excel worksheets [Closed]

Report
Posts
2
Registration date
Friday January 12, 2018
Status
Member
Last seen
January 13, 2018
-
Hello,
I need to compare one Excel Sheet1 with Sheet2 by comparing the data and putting all missing rows data not in Sheet2 into Sheet3.
Sheet1 contains a list of:

Name ID Status
Brian 1 In
Tess 2 In
Shay 3 In
Peter 4 In
Gary 5 In

Sheet2 contains similar list but rows are missing

Name ID Status
Brian 1 In
Shay 3 In
Peter 4 In

Sheet three must display the Heading and only the missing rows