Add and Sort

[Paul_Hossler]

Hello,

I have two list of number on two separate sheets. I am trying to figure out how to compare the two lists, add the numbers that are on list one that don't exist on list two to list two and finally sort them so they match. I have attached a workbook and this what I have so far:

If a number is on List1 but not on List2, then add it to List2

What if there's a number on List2 that is not on List1?

No matter how you sort, they'll never match