macro to check for duplicates and copy data if no duplicate found

[lwayl]

Hi,

I am trying to write a macro that runs when sheet2 is clicked on. what im tying to get the macro to do is checks all the entries (which are names of people) in sheet 1, column B and looks for duplicates in sheet2 column B. If a duplicate is not found in sheet2, it will copy link all of that row to sheet2. Also, if a cell is found blank in sheet1, to just skip it. I have tried looking in the forum for help but all the codes i find are doing for i=1 and j=1, then loop. From my understanding, this is just checking one cell against another cell and then truncating by one, assuming that the duplicated will fall on the same row. I need a macro that compares each cell with the whole list. Any help would be appreciated. Thank you.

[skywriter]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Trebor76]

Cross-posted and potentially solved here