I have come across a situation where i have to compare the inventory and update it with up to date prices.
For Example i have these two lists
Current List
Item No. Price
Item 1 12
Item 2 19
Item 3 17
Item 4 14

Updated List
Item No. Price
Item 3 21
Item 1 15
Item 4 19

Required Results: I want to sort the updated list and place it in front of Current List. And remember there are thousands of entries so for the missing items in Updated List i just want to delete them. This is what i am looking for.
Current List Updated Price
Item No. Price Item No. Price
Item 1 12 Item 1 15
Item 2 19 ------ ---
Item 3 17 Item 3 21
Item 4 14 Item 4 19

If there is any solution that does not involve VB or Macro that will be very easy for me.