I have a spreadsheet that Im having some issues with, I dont use code very often and it has been a long time since I created this macro and have forgotten what everything means. This code creates creates formulas in cells S3 down to S7.

Please Login or Register  to view this content.
The way it is work now S3 is populated with the right formula

S4 is populated with 
Please Login or Register  to view this content.
but should be D16 in stead of D17 at both instances in the formula

S5 is populated with 
Please Login or Register  to view this content.
but should be E16 in stead of E18 at both instances in the formula


S6 is populated with 
Please Login or Register  to view this content.
but should be F16 in stead of F19 at both instances in the formula

S7 is populated with 
Please Login or Register  to view this content.
but should be G16 in stead of G20 at both instances in the formula

Can someone look at my code and let me know what to change to make it populate these formulas correctly.

Thanks
Weston