Compare two lists and copy unique values to the second list

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.