Correct and compleate a VBA excel script -- 2

Job ID: 36822417

Budget: $10 – $30 AUD

Correcting and completing a small Excel VBA code based of a working and existing VBA code I am happy to share in the document attached. I can share the Excel file upon request. The attached word document has the description of what I need it to do and below this the VBA code as I have adjusted it so far. The column to the right, greyed ot, is the original code that works fine.
Related categories: Visual Basic Excel