Macro or forumla delete duplicate rows from two tabs in spreadsheet?

[jenta001]

I have a large spreadsheet with two tabs - Tab A. Prospects (6,000 rows), Tab B. Clients (9,000 rows) which contain client names and numbers. I have included a small sample of the spreadsheet.

I am trying to cull down Tab A. Prospects to not include any data which occurs in B. Clients:

•If a Client No, Search Key or Client Name from Tab B. Clients also occurs in Tab A. Prospects, then I want to delete it from Tab A. Prospects.
•Duplications of data in A. Prospects is fine, so long as none of the data also appears in Tab B. Clients

Thanks in advance for your help - if there is any extra info you need please let me know!

[xladept]

Hi Jenta,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[jenta001]

Oh I could jump up and down I'm so happy this worked! Thank you so much

[xladept]

You're welcome! Thanks for the rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.