Compare Excel worksheets

Closed

Biffzs Posts 2 Registration date Friday January 12, 2018 Status Member Last seen January 13, 2018 - Updated on Jan 12, 2018 at 12:46 PM

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

Compare Excel worksheets
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Transfer data from one excel worksheet to another automatically - Guide
Excel date format dd.mm.yyyy - Guide
VBA Compare 2 sheets and output difference to 3rd sheet - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum

Subscribe To Our Newsletter!