Compare two lists and copy unique values to the second list

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.