Not copying duplicates

[nathan.volker12]

Hey guys,
So I have this code here written that takes the selected area and copies it for me based off the cells that I want the values from. How do I check to see if the values that are being copied already exist to where they are being pasted to.
As an example lets say its coping John (Cell F), and 29 (Cell Q)
Its going to post at the first empty cell of text from B39 from top down. How can I get it to check above the first empty cell to see if John is already listed and 29 is already listed?
Have I taken the wrong approach on this?

Please Login or Register  to view this content.

[Kaper]

Check if there are such values in columns B and C. For instance with COUNTIFS function (of course called within VBA):

Please Login or Register  to view this content.