How to increment a cell reference in a row

[Mike]

I have a row of cells. The first cell in the row is ='05.09'!M7. I need the
second cell in the same row to be incremented by 7 ex: ='05.09'!M14 and the
following cells in the same row to be incremented by 7 continously. It would
look like this cell one ='05.09'!M7 cell two ='05.09'!M14 cell three
='05.09'!M21 cell four ='05.09'!M28.

How can I add 7 to the first cell and drag over the remaining cells in the
row.

The data from ='05.09'!M7 is in a different worksheet and in columns not rows.

Any help would be appreciated.

Thanks,

 

[Jacob Skaria]

In row 1 enter the below formula and copy that down..It picks the row number
and multiply by 7

=INDIRECT("05.09!M" & ROW()*7)

If this post helps click Yes

 

[Jacob Skaria]

In row 1 enter the below formula and copy that down..It picks the row number
and multiply by 7

=INDIRECT("05.09!M" & ROW()*7)

If this post helps click Yes

 

[Mike H]

Hi,

Try this

=INDEX('05.09'!M:M,(ROW(A1)-1)*7+7)

Mike

 

[Mike H]

Hi,

Try this

=INDEX('05.09'!M:M,(ROW(A1)-1)*7+7)

Mike

 

[Mike H]

Jacob,

Suitably modified it doesn't have to go in row 1

=INDIRECT("05.09!M" & (ROW(A1)-1)*7+7)

Mike

 

[Mike H]

Jacob,

Suitably modified it doesn't have to go in row 1

=INDIRECT("05.09!M" & (ROW(A1)-1)*7+7)

Mike

 

[Mike]

Sorry, I might have not explained myself very well so here is an example of
what I am trying to do.

Cell 1 needs to pull from 05.09'!M7 to get the value 22. Then I would like
to put into Cell 2, Cell 3 and Cell 4 a formula to increment 05.09'!M7 by 7
so I can avoid so much keying. Consequently, I am pulling from columns and
placing the data into rows.

I tried the =INDIRECT("05.09!M" & ROW()*7) but it did not work. Also tried
Column inplace if row.

Worksheet Reptg Data in Rows
Cell 1 Cell 2 Cell 3
Cell 4
=05.09'!M7 22 =05.09'!M14 33 =05.09'!M21 44 =05.09'!M28 55

Worksheet 05.09 in columns
05.09'!M7 value is 22
05.09'!M14 value is 33
05.09'!M21 value is 44
05.09'!M28 value is 55



This help?

 

[Mike]

Sorry, I might have not explained myself very well so here is an example of
what I am trying to do.

Cell 1 needs to pull from 05.09'!M7 to get the value 22. Then I would like
to put into Cell 2, Cell 3 and Cell 4 a formula to increment 05.09'!M7 by 7
so I can avoid so much keying. Consequently, I am pulling from columns and
placing the data into rows.

I tried the =INDIRECT("05.09!M" & ROW()*7) but it did not work. Also tried
Column inplace if row.

Worksheet Reptg Data in Rows
Cell 1 Cell 2 Cell 3
Cell 4
=05.09'!M7 22 =05.09'!M14 33 =05.09'!M21 44 =05.09'!M28 55

Worksheet 05.09 in columns
05.09'!M7 value is 22
05.09'!M14 value is 33
05.09'!M21 value is 44
05.09'!M28 value is 55



This help?

 

[Mike H]

Jacob's formula does exactly that but you must put it in row 1. My formula
can be put in any row and when dragged down gives the reult you want

Mike

 

[Mike H]

Jacob's formula does exactly that but you must put it in row 1. My formula
can be put in any row and when dragged down gives the reult you want

Mike

 

[Mike]

Thanks,

The =INDIRECT("05.09!M" & (ROW(A1)-1)*7+7) worked great. I did need to
change the (ROW to (COLUMN. After that it worked great.

Much thanks, this will save me time and increase the accuracy of the report.

 

[Mike]

Thanks,

The =INDIRECT("05.09!M" & (ROW(A1)-1)*7+7) worked great. I did need to
change the (ROW to (COLUMN. After that it worked great.

Much thanks, this will save me time and increase the accuracy of the report.