Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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
---
"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

Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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

Did you try the formula? What results did you get?

Fill in a formula within a worksheet
 

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
---
"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

Fill in a formula within a worksheet
 

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 -

Fill in a formula within a worksheet
 

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

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.

Fill in a formula within a worksheet
 

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

Fill in a formula within a worksheet
 

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.