Fill in a formula within a worksheet

Tracy wrote:
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: Please ignore what you THINK the formulas offered will do and try them
and see what they ACTUALLY do. You have successfully communicated what you want.

Works for me.

I entered =OFFSET(CallList!$A$112,COLUMNS($A:A)-1,) in A1 of a new sheet.

Dragged across to Z1 and returns the contents of CallList A112:A137


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 12:56:04 -0700, Tracy
wrote:

I tried that, but it does not increase the rows, only the columns
--
Tracy


"Max" wrote:

One way, in the starting cell, put:
=OFFSET(CallList!$A$112,COLUMNS($A:A)-1,)
Copy across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik

Although now, Tracy, you have a difference set of cell references compared
to what you originally posted. Try this amended formula:

=INDIRECT("'CallList'!E"&(816+COLUMN(A1)))

Note that the 816 gets added to COLUMN(A1) within the inner brackets, so
that returns 817, and that then gets joined on to "CallList!E" to form the
cell reference CallList!E817 - the INDIRECT function allows you to calculate
cell references in this way.

Hope this helps.

Pete

"Glenn" wrote in message
...
Tracy wrote:
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: Please ignore what you THINK the formulas offered will do and try
them and see what they ACTUALLY do. You have successfully communicated
what you want.