Macro to insert rows for non-matched values

[goldfrapp01]

Hi,

I think my code is 90% ready but there is a case I can't resolve, please help!

My current macro works partially, it finds which codes are missing from the report (compared to a master list on another worksheet) with a Match method and it appends them to the end of the report. This works perfectly. However, instead of appending them to the end, I'd like to insert the codes in the same order as in the master list. Is this possible?

I can't sort alphabetically to fix the problem, because the report comes with "Subtotal" lines for each section (non-Excel generated) and if I sort - all subtotals will be grouped together. Also the sequence of the coding might not always be alphabetical.

thanks!

https://www.dropbox.com/s/o2izvoowyaibhyn/sample.xlsm

[goldfrapp01]

Anyone? The above codes does not store the address of the last matched value, so I don't know how to insert a row right after it. Please help!