I am trying to write a simple Excel equation that

Question

Basically, I'd like to use cell R1 "value A" right now to fill 60 rows from H242 to H301, then have the equation skip to S1 "value B" and fill the next 60 rows from H302 to H361. Then continue on with this 60 repeat, +1 column over, 60 repeat, etc.

Is there a way to do this using excel equations or programming in Excel?

Sorry if this is a bit noobie, I tried looking for an answer of the last 2 hours but couldn't find what I was looking for possibly because of my inability to search for the correct thing.

Answer 1

There is no need for a macro.

In H242 enter:

=INDEX(R$1:ZZ$1,1,ROUNDUP(ROWS($1:1)/60,0))

and copy down.

NOTE:

You may need to modify the ZZ if you need more data.