How to repeat a pattern?

I have data taken every 60 minutes every day for three years with six hours a day. I have my data in a column, let's say G. In column H I have:
H2 =G2-G$1
H3 =G3-G$1
H4 =G4-G$1
H5 =G5-G$1
H6 =G6-G$1
H7 =G7-G$1
H8 =G8-G$7
H9 =G9-G$7
H10 =G10-G$7
Column H is every hour's data minus the closing price of the day before, which is every sixth cell or cells 1, 7, 13, 19, ....6n-1.
I have 40,000 cells (I have SP500 every 10, 30, and 60 min) and I was wondering if there was a way to repeat this pattern or if I have to do it all manually.

Thanks a bunch.

Hi, and welcome to the forum.

Assuming data starts in row 1, in H2 try:

=G2-INDIRECT("G$"&INT((ROW()-2)/6)*6+1)

and copy it down.

HTH

Thanks for your suggestion. I really appreciate that. Luckily, I got help writing a module in VB.