It still does not incrementally go up by rows, it goes up by the Call List
columns.
--
Tracy


"Pete_UK" wrote:

Put this in A1:

=INDIRECT("'CallList'!A"&(111+COLUMN(A1)))

Then you can copy this across.

Hope this helps.

Pee

On Aug 26, 5:25 pm, Tracy wrote:
I have the following formula which I need to fill across the worksheet but
the cell reference is from another sheet and the information within the other
sheet goes down the page not from left to right?

Colum A Column B
=+'CallList'A112 =+'CallList'A113

Tracy