Compare two worksheets and put the

Closed
Report
Posts
4
Registration date
Thursday April 27, 2017
Status
Member
Last seen
May 23, 2017
-
I have a workbook with 5 worksheets.

"PreviousFN", "CurrentFN", "OmittedMbrs", "NewMbrs" and "CommonMbrs".

EID is the unique key.

The following are records in "PreviousFN"

EID Surname GivenName Pay <<< Heading

14123 Prabhu Raghu $2,721.00
14124 Jain Sanjay $2,727.00
14125 O’Connell Greg $2,222.00
14126 Nitiskas John $3,425.00 << member dropped out
14127 Sawant Bhanu $2,263.00
14128 Evans Craig $2,440.00
14129 Sawant Vim $2,721.00
Pay Day 06APR14

The following are records in "CurrentFN"

EID Surname GivenName Pay <<< Heading

14123 Prabhu Raghu $2,821.00
14124 Jain Sanjay $2,727.00
14125 O’Connell Greg $2,222.00
14127 Sawant Bhanu $2,263.00
14128 Evans Craig $2,440.00
14129 Prabhu Vim $2,721.00
14130 Kamath Sunil $2,222.00 << new member added

Can someone help me with the code to compare and put the common EID from both the sheets into "CommonMbrs", put member that dropped out in "OmittedMbrs" and the new member into "NewMbrs"?

Thanks Regards

Raghu