Help with automating

[karthuappu]

Need help in automating the formulas

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

 

[karthuappu]

 

[DataBlake]

coukd you clarify what you mean by "reference row"
Also you can't attach files on this forum try checking out this sticky for other solutions or share via google docs or drop box.
image url's also look with the picture insert.

 

[karthuappu]

im not allowed to share the file ;
if you notice the formula the reference or cell used moves by 18 ie from N509 to N527
i need to automate that.

Thanks

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1278402-help-with-automating.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[karthuappu]

https://www.excelforum.com/excel-general/1278402-help-with-automating-using-maybe-sum-and-offset.html#post5132671

[url]https://www.reddit.com/r/excel/comments/bx22gx/help_with_automating/
[/URL]

 

[Fluff]

Can you please post the links to the other sites where you have asked this question.

 

[karthuappu]

can anyone please help

 

[Fluff]

As requested, please post the links to the other site(s) where you have asked this question

 

[karthuappu]

i have reported the post with links in the comments as im unable to edit the post