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.