Need VBA script

Job ID: 34204122

Budget: $2 – $8 AUD

Hello ,
I have one small task which need to performed automatically with excel Vba scriptis or function my budget is 10$ max please dont bid and start asking more than my budget . I am attacting my file sample with raw and output which i want . Please big if you agree with all thank you.