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