Compare two lists and copy unique values to the second list

Hi all,

I'm having a problem. I have a spreadsheet where the values in column C should contain all of the values in A (starting from C3 and A3). Column C may contain values that are not in A.

Effectively, what I would like the macro to do, on a button push, would be to look at the values in A, check to see if the values is in C, and if it is not, copy the value to the next available row in C.

Any bright ideas? All help is much appreciated.

Originally Posted by AB33

You can use Index and match, but if you want a code, please attach your sample.

It has to be hard coded. It will become apparent when you see the sheet. Column A of 'RM Input Table' is a pivot based on the query in 'RM Query'. I need to copy the missing values from A into C to hardcode those values - I then plan to index/match the relevant data from RM query into the rest of the table and then be able to add my own data at the end.

Thanks.

Hi Brumbot,

Can you post a sample workbook indicating your expected results ? thanks.


Regards,
DILIPandey
<click on below * if this helps>

Originally Posted by akhileshgs

I dont think that macro is required. Please have a look at the attached fileAttachment 241087

OK. The values in the left hand list may change as information is deleted from the database. Since I have hardcoded inputted information from the user in the blue areas of my spreadsheet (right hand side), if I were to use an index/match, the number would change, but the hardcoded information would remain in the same place and not refer to the correct number. I assure you, it has to be coded.

I should add that if a value drops off the column A, and is already in C, it should remain in C.

Originally Posted by nilem

Hi Brumbot,
maybe so

Please Login or Register  to view this content.

This is great! Other than the fact that if it finds one in the middle of the range that is not included in C, it pastes it with a 1 row gap at the bottom. Is there any way to make it so that it paste without the gap?

Originally Posted by nilem

It is not very clear. Can you show a small example of this

Never mind. This works as expected. Thanks very much for your input.