Can I Reference a Cell “Number†Dynamically?

[CRayF]

Can I Reference a Cell “Number†Dynamically?

As an example, =Total_Used!A10

On the current worksheet I will replicate this line, In
Cell A1 I have =Total_Used!A7
Cell A2 I have =Total_Used!A14
Cell A3 I have =Total_Used!A21
And so on…

If I replicate this line on the current worksheet, it will say:
Cell A4 I have =Total_Used!A22 instead of A28 (increments of 7)

Is there a way to reference this cell in increments of 7?
I can add a hidden column that has the row reference i.e. Cell X1 = 7, the
say X2 = X1+7 But I can’t figure out a way to use this cell X as the number
portion of a cell call. i.e. Instead of =Total_Used!A14
To use something like =Total_Used!A(the value of X2)

Is there a way to make do this?

 

[John Green]

Use the OFFSET function:

In A1 enter

=OFFSET(Total_Used!$A$7,(ROW()-1)*7,0)

and copy down.

John Green - Excel MVP

 

[Vacation's Over]

Look at Offset command to allow numbers & math for cell addresses

 

[CRayF]

thank you - problem solved