Roger,
Thank you for the information, but maybe I didn't put the question correctly.

I have a function in one worksheet which pulls information from another
worksheet
Worksheet "Call List" E817

In another worksheet I want to put the information from Call List E817 in
that cell and copy to the right that formula while increasing the row number
only from the Call List worksheet.. E817, E818, E819. Everytime I try to
copy or fill to the right column "E" changes and not the row.
--
Tracy


"Roger Govier" wrote:

Hi Tracy

Try
=INDIRECT("'CallList'!A"&COLUMN(A112))

As you copy across the sheet , Column() will increase, to give you the
values from successive rows.
--
Regards
Roger Govier

"Tracy" wrote in message
...
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