remove duplicate names from different sheets and past only unique names in another sheet

Hi,

I have below code which is used for removing dupicates from 2 sheets (EMP Date Specific) & (PDR Date Specific) and pasting only unique values in "Sheet6".
problem with this code is I need the unique values to be pasted in Sheet7. So I have tried replacing "Sheet6" to "Sheet7" in below code but it is not working... please please advise.

Please Login or Register  to view this content.