VBA Loop to Look up using Left and Right Function for months

Hi

Ok bit stuck on trying to figure out the best solution while my vba skills are limited at best.

I have TWO sheets. Sheet 1 "GOODS" & Sheet 2 "Master"

I have Sales by monthly in "Master" and i want to split the sales evenly by week in "GOODS" keeping in mind some weeks have 5 Mondays and some have 4. For this i have a formula to determine this, now i'm trying to figure out the best way to macro copying the sales to weekly as i have 100s of them each month.

I have each monthly Sales stored in a Variable "Value1", "Value2"......."Value12" in a For Next Loop

I was thinking of using a lookup in a loop somehow to read the first 3 characters on the month in "Master" with the LEFT Function to determine which month of sales (eg) "Jul" then to split the monthly sale of 50 to 10 each week as there is 5 starting weeks in July.

Master Sheet
2Capture.PNG

Goods Sheet
Capture.PNG




Any assistance is greatly appreciated.

Thanks