Help with automating

[karthuappu]

Need help in automating the formulas

the reference row needs to move by 18 everytime.
Could someone please help
Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1100039-help-automating.html#post5288868

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).