Excel Math Wizards
 

Ok, I currently have the following formula:


Code:
--------------------
=CONCATENATE(INDIRECT("'Gross%'!A" & (ROW(A28)+32)/6), " ", INDIRECT("'Gross%'!B" & (ROW(A28)+32)/6))
--------------------


The blue portion is what needs to be changed.

It references another sheet in the book and worked fine until I had to
modify the other sheet to add a row between all existing rows.

The initial sheet uses this formula on every sixth line (4,10,16,22,
etc.). The source sheet holds the data on every odd line (5,7,9,11).

The correlation between books is constant. (child book row-parent book
row,4-5,10-7,16-9,22-11).

Any ideas what the formula would be for this?


--
scain2004
------------------------------------------------------------------------
scain2004's Profile: http://www.excelforum.com/member.php...fo&userid=7051
View this thread: http://www.excelforum.com/showthread...hreadid=475145

Replace
(ROW(A28)+32)/6

with
(ROW(A7)+8)/3

HTH,
Bernie
MS Excel MVP



"scain2004" wrote
in message ...

Ok, I currently have the following formula:


Code:
--------------------
=CONCATENATE(INDIRECT("'Gross%'!A" & (ROW(A28)+32)/6), " ",
INDIRECT("'Gross%'!B" & (ROW(A28)+32)/6))
--------------------


The blue portion is what needs to be changed.

It references another sheet in the book and worked fine until I had to
modify the other sheet to add a row between all existing rows.

The initial sheet uses this formula on every sixth line (4,10,16,22,
etc.). The source sheet holds the data on every odd line (5,7,9,11).

The correlation between books is constant. (child book row-parent book
row,4-5,10-7,16-9,22-11).

Any ideas what the formula would be for this?


--
scain2004
------------------------------------------------------------------------
scain2004's Profile:
http://www.excelforum.com/member.php...fo&userid=7051
View this thread: http://www.excelforum.com/showthread...hreadid=475145

Thanks,

I had to modify slightly:

((ROW(A4) + 8)/3) + 1

to get odds, but thanks for your help.


--
scain2004
------------------------------------------------------------------------
scain2004's Profile: http://www.excelforum.com/member.php...fo&userid=7051
View this thread: http://www.excelforum.com/showthread...hreadid=475145

They're equivalent:

(ROW(A7)+8)/3 = (7+8)/3 = 15/3 = 5

((ROW(A4) + 8)/3) + 1 = (4+8)/3+1 = 12/3+1=4+1=5

HTH,
Bernie
MS Excel MVP


"scain2004" wrote
in message ...

Thanks,

I had to modify slightly:

((ROW(A4) + 8)/3) + 1

to get odds, but thanks for your help.


--
scain2004
------------------------------------------------------------------------
scain2004's Profile:
http://www.excelforum.com/member.php...fo&userid=7051
View this thread: http://www.excelforum.com/showthread...hreadid=475145