From the Developer tab, click on Visual Basic. This takes you to a higher-level project view of your workbook, the column at left shows...

Plz download the question from the attachments. Please read the Q3 introduction because it shows how  to build a VBA formula for the Q3. 

The Q4 is based on Q3.

Plz upload your excel files and give me a screen shot of your VBA code

• Attachment 1
• Attachment 2
• Attachment 3