Sum every 7 rows in another sheet and paste result

[Yulyo]

Hello all,

I have a very urgent situation, if you can help me:
- I need a vba to look in sheet4, make the sum between every 7 days (c2:c8), and copy the result in sheet1 H7, then go again to sheet4, make the sum between next 7 days (c9:c15) and copy the result in sheet1 h8, and so on for every 7 days...


Please download the test file:
https://drive.google.com/open?id=1rZhy9iSQfRQlk-mEf9j3kjcc3rvY9W_i

Thank you in advance!

 

[wideboydixon]

Why not simply use a formula in H7 and copy down?

=SUM(INDEX(Sheet4!$C:$C,ROWS($H$7:$H7)*7-5):INDEX(Sheet4!$C:$C,ROWS($H$7:$H7)*7+1))

WBD

 

[Yulyo]

Thank you very much wideboydixon,
Everything it's working almost perfectly on the test file.
Tha only problem is that in my working file, KW7 starts on row 1876 on sheet4 and i can't get it to work...

 

[wideboydixon]

I think you just need to adjust the rows:

=SUM(INDEX(Sheet4!$C:$C,ROWS($H$7:$H7)*7+1869):INDEX(Sheet4!$C:$C,ROWS($H$7:$H7)*7+1875))

WBD

 

[Yulyo]

Everything is perfect now.
Thank you very much mate!