The data starts in row 9 in wksht1 and row 8 in wksht2.

Having a third worksheet is best because when I am on leave someone else can run the macro and see at a glance any new codes that need to be added. Non many know how to use Autofilter.