Sheet (result) displays a number of sales orders (1 row per order).
Column F displays the list of stock codes that have sold. There will be a number of duplicates throughout the column because there are multiple orders for multiple products.
I want to add some additional stock codes to the end of this column.
Sheet (file margin) displays all of my available stock codes. A number of these codes will appear in (col F) on the (result ) sheet.
I would like all of the codes from col A (file margin) that don't appear in (col F result ) to be added to the bottom of col F (result) from cell F:22014 downwards