Worksheet Merging

[richwind85]

Hi

I have two worksheets, One with Master data which I do not want to change, and a second with some of the same data and some which is not on the master sheet.

They do have several unique Identifiers and the data is on a whole row.

I want to merge the two and add any of the lines which are on the second sheet which isn't on the Master one.

So if Emp Number 123456 (in cell d) is not the Master sheet but is in the Second sheet then copy the whole row to the combined sheet.

Both sheets are exactly the same format

Any help would be much appreciated.

Thanks

[Pepe Le Mokko]

Perhaps copy paste the second range on the first sheet under the original one, then use "Remove duplicates" on the Data ribbon?