H

I have 2 worksheets of client information that I need to sort by the empl_ID. The Empl_ID is the unique identifier for each client. There are 678 records in one sheet and 789 records in the other sheet

Each sheet may have some identical Empl_ID which is fine. BUT sheet 1 may have Empl_ID which are NOT in sheet 2 and Vice Versa

What I need to do is to have a way merge both sheets into a new worksheet showing only one of each Empl_ID. For instance, if both sheets have an identical Empl_ID, I only want to see it once in the new sheet. Also, anywhere where there is only an Empl_ID in one of the sheets, this Empl_ID will need to be pulled in also. So, from 678 records in sheet 1 and 789 records in sheet 2, we may end up with a NEW WORKSHET containing 900 or so records

I hope this makes sense

Any help will be greatly appreciated

Kind regard

Malcolm Davidson