Need to cascade a formula every 24 lines

Hi guys, and thanks in advance for the help.

I need to copy a formula to every 24th line, but need the referenced cell to only increase by 1.

In this example cell C8 needs to reference a cell from a worksheet named v3i33

C8=v3i33!A2

I need to copy the formula down 24 lines at a time, so that:

C32=v3i33!A3

C56=v3i33!A4

C80=v3i33!A5

and so forth...any suggestions? I have to repeat this formula over 500 times, so entering it manually isn't an option.

Not having any luck getting that macro to work. I am running another macro on this worksheet, so I'm somewhat familiar with the process. I added the macro, but when I try to use it as a function, it says "name not valid". This is probably user error...I'm not an Excel expert by any means.

Also, I'd like to be able to accomplish this with a formula if possible. If I explain what I'm doing perhaps it will give you some insight. In one worksheet, I'll have data for all of my customers. In another worksheet (same document), I will have 500 invoices that need to be populated by the other worksheet. So C8 is the location of the Store Name on the first invoice, C32 is the Store Name for the second invoice. My reason for preferring formulas is that I can repopulate the invoices to the most current worksheet just by doing a simple Find/Replace to update the formulas to pull from another worksheet. (i.e., replacing v3i33, which is the worksheet i'm referencing to v3i34.)

Originally Posted by Ace_XL

In C8

=IF(MOD(ROW(),24)=8,INDEX(v3i33!A:A,INT(ROW(A1)/24)+2),"")

Copy down

Thanks everyone for your contributions! Ultimately, Ace's formula is the one that led me to salvation. I actually couldn't use it directly, as my cells were sized and formatted differently for some of the following rows, and Excel wouldn't allow me to copy down. What I did eventually was use some columns outside of the print area to calculate the formulas then used the OFFSET function to reference them in the actual invoices. Other than that it worked perfectly, with the exception of one column that I can't get it to pull reference data for some reason. I don't really understand why...yet...still playing with it. Many thanks though! I've made a lot of progress with your help.