Compare Excel worksheets [Closed]

Biffzs 2 Posts Friday January 12, 2018Registration date January 13, 2018 Last seen - Jan 12, 2018 at 12:45 PM - Latest reply: Ambucias 51180 Posts Monday February 1, 2010Registration dateModeratorStatus April 25, 2018 Last seen
- Jan 12, 2018 at 04:21 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

See more 

1 reply

Ambucias 51180 Posts Monday February 1, 2010Registration dateModeratorStatus April 25, 2018 Last seen - Jan 12, 2018 at 04:21 PM
0
Helpful
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator