In A1 the formula will contain COLUMN(A1) which evaluates to 1, which
in turn is added onto A111 to make A112 in the CallList sheet. When it
is copied into B1 then that part of the formula will show COLUMN(B1)
which returns 2 and hence the reference is to A113 in the CallList
sheet. Similarly in C1 it will show COLUMN(C1), returning 3 and making
a reference of A114, and so on.

So, although the word COLUMN appears in the formula, this translates
into the appropriate ROW of the CallList sheet.

Try the formula - see what happens (put some values like A, B, C in
those consecutive cells A112, A113, A114 etc of the CallList sheet and
you should see A, B, C etc returned across the row).

Hope this helps.

Pete

On Aug 26, 8:42*pm, Tracy wrote:
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.

Pete

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- Hide quoted text -

- Show quoted text -