Im trying to compare two sheets which have some of the same data. Im looking for a way to compare the two sheets and for the unique data on each of them to be copied to a new spreadsheet . .i can do it with a pivot table and then pivoting them off the originals again to find out which sheet it came from , this approach works on small sheets but when i have anything over a few thousand there is to much unique data and the pivot wont allow it.

Any help or suggestions would be appreciated (dont really wanna go making a macro for it )