Adding Names to a Column A when they appear in Column B but not A

**HCLax** · 06-16-2015, 03:56 PM

Hello,

So I have a list of Unique names in Column A of Worksheet 1 as well as a list of names that is in Column A of Worksheet 2. All of the names in Worksheet 1 exist in Worksheet 2, but the list in Worksheet 2 contains duplicate names as well as some names that do not exist on Worksheet 1.

I need a Macro that can identify all of the names in Worksheet 2 that do not exist in worksheet 1 and add them at the bottom of the list in worksheet 1.

So far I have been able to compile the list in Worksheet 2 so that a separate sheet displays only the unique values in worksheet 2, but I am not sure how to determine which in this new list do not exist in Worksheet A and proceed to insert those values.

Thanks,

Justin Picardi

**Leith Ross** · 06-16-2015, 04:10 PM

Hello Justin,

This is really a continuation of your previous post here.

I suggest you change the name of this post to something a little different and mark the previous as solved.

**xladept** · 06-16-2015, 04:10 PM

Hi Justin,

Take the names from worksheet 1 into your dictionary and then run the names in worksheet 2 against that dictionary

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

**PCI** · 06-16-2015, 04:29 PM

See next code

Please Login or Register  to view this content.

**JoeFoot** · 06-16-2015, 04:49 PM

I already replied to you on the 1st thread and I think that was the solution you needed.

If you need to increment in the list of worksheet1 instead of removing it and creating anew then the following code will do that:

Please Login or Register  to view this content.

this code reads all the items in worksheet2 and if the names are unique and not present in worksheet1 it will increment the list on that sheet. This code assumes all your lists start in row1 (both sheet1 list and sheet2 list). If you change the list on sheet2 and re-run the code, it will increment list1. It will not delete the current components of it.

See if that helps.

**jindon** · 06-16-2015, 05:10 PM

Copy ColA from Sheet2 and add below the data in Sheet1 Col.A then RemoveDup...
Assuming both sheets have header in row 1.

Please Login or Register  to view this content.

**HCLax** · 06-16-2015, 05:52 PM

Thanks PCI,

This is the type of thing I am looking for I am just struggling to get it work when the Lists I am trying to work with are both in Row C of their Sheets and there are values in Rows A and B. Are there any Changes I can make to fix this?

Thanks,
Justin

**kalak** · 06-16-2015, 06:35 PM

re: post# 6 using RemoveDuplicates

Suppose you have in Sheet 1, Col 1
HdrOne
10
9

and in Sheet 2, Col 1
HdrTwo
10Q
9

Or even if the data (i.e. "names") on each sheet are just numbers such as 1 and 2, but formatted differently.

Using RemoveDuplicates gives me a different result from other removing duplicates approaches such as advanced filter or dictionary object.
So, how useful is this method and why is it suggested for this type of problem?

**xladept** · 06-16-2015, 06:51 PM

Hey Justin,

How about a sample??

**jindon** · 06-16-2015, 07:26 PM

Originally Posted by kalak

Using RemoveDuplicates gives me a different result from other removing duplicates approaches such as advanced filter or dictionary object.
So, how useful is this method and why is it suggested for this type of problem?

No idea about what you are talking about.
Dictionary also detects data types....

**kalak** · 06-16-2015, 07:41 PM

Quote Jindon
No idea about what you are talking about.
Dictionary also detects data types....

Obviously you didn't try it.
Perhaps you should just try the data I suggested and then report your findings.

**jindon** · 06-16-2015, 08:08 PM

OK, in that case, remove dups is not working, istead, still no loop requred

Please Login or Register  to view this content.

Adding Names to a Column A when they appear in Column B but not A

LinkBack

Thread Tools

Rate This Thread

Display

Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Re: Adding Names to a Column A when they appear in Column B but not A

Thread Information

Users Browsing this Thread

Similar Threads

Formulas to see if names in one column exists on the names in the second column

Combine rows by adding amounts found in column d for duplicate names in Column a

How to sum 1 column I have a two-column array, where column 1 is a list of names and

adding column with corresponding names

Adding Checkboxes to Form based on how many names in column?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions