Copying a specific cell same row but every 7th column

[Szucchari]

I have a worksheet that I need to copy cells in row 7 but I only the information from every 7th column for now. For example, the first few cells I need to copy are C7.J7,Q7. This file goes on for years worth of data.
I tried =OFFSET(C7,0,7) which worked for the following cell but when I drag it down, I cannot get it to stop picking up cell C8. I think I need it to pick up J7 so it will copy the next 7th column but I am not sure.
I am not great with VBA but I am learning.
I know my example is in google sheets but I do need it for excel 2016. I have excel on my work PC.

 

[Fluff]

How about, in D30 dragged down

=INDEX($C$7:$X$7,ROWS(D$30:D30)*7-6)

 

[Szucchari]

How about, in D30 dragged down

=INDEX($C$7:$X$7,ROWS(D$30:D30)*7-6)

It works thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.