How Can I Increment A Formula By 1 For A Group Of Formulas

[halocrew2003]

Currently what is happening is that Im attempting to increment the formula +1.

for example here is what is in b1-b4:

Please Login or Register  to view this content.

if I select all 4 rows and paste it directly below "b4" it gives me this:

Please Login or Register  to view this content.

when I really want this:

Please Login or Register  to view this content.

How can I accomplish this? I only want it to increment +1 for the for every time I paste.

[Tony Valko]

Let's assume you want to link to the range Mark!A8:A12.

Enter this formula in B1 and copy down to B20:

=INDEX(Mark!A$8:A$12,CEILING(ROWS(B$1:B1)/4,1))&" - "&Config!A$4

[halocrew2003]

thanks that worked. Got one more for you if you or anyone could assist:

Basically I have this formula:

=(MIKE!$B8)

and I have a bunch of cells withs Numbers like so:

Cell | Cell Number Change
C1 | 10
C2 | 16
C3 | 29
C4 | 40
C5 | 61

What I want to do is to be able to change the number "8" for the formula by referencing a cell to grab a number, which will thus change the formula and the output of the data. I'll use it to copy and paste down and change the numbers out to get only the output of different cells that I need.

[Tony Valko]

Not sure I understand.

C1 = 10

=INDIRECT("Mike!B"&C1)

Evaluates to:

=Mike!$B$10

Is that what you want?