Don't know whether the last info went through, but the columns are
incrementally increasing, not by the rows from the Call List worksheet.
--
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