Once again Thank you Pete for all your help.
--
Tracy


"Pete_UK" wrote:

Try this, then, Tracy:

=IF(INDIRECT("'Call List'!B"&(816+COLUMN(A1)))=1,INDIRECT("'Call List'!
D"&(816+COLUMN(A1))),"Not in Use")

The $ symbols are not required here as the references to B and D will
not change as they are text values.

Just copy this across as required.

Hope this helps.

Pete

On Aug 27, 2:50 pm, Tracy wrote:
Pete, one more question if I can be so bold to ask.
Can you take this formula and make it able to copy across like the other
formula increaseing the cell 817 to 818, 819, etc..?

=IF('Call List'!$B$817=1,'Call List'!$D$817,"Not in Use")
--
Tracy



"Pete_UK" wrote:
Tracy,

please put this formula in G7 of the Div 6 sheet:

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

then copy it across the row. You will get:

bob ted bill etc

as required.

Hope this helps.

Pete

On Aug 26, 10:32 pm, Tracy wrote:
I posted this question this morning, but I did not get a resolve.

Maybe this is a little more clear.
I have two worksheets within my file

Worksheet called "Call List" and another called "Div 6"

Within the Div 6 worksheet I have a formula in cell (G7) which copies
information I already input from cell E817 from the Call List wksht. I now
want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent
to the right while increaseing the formula from the Call List worksheet by
one row. So I am filling/copying a formula to the right from a worksheet
that has the information going down. Everytime I try to copy the formula the
column keeps increasing instead of the row, i.e E817, G817 when I want the
formula to read E817, E818, E819, ect.

Call List Worksheet Div 6 Worksheet
E G H I
817 bob 7 bob (from E817) E818 E819
818 ted
819 bill

--
Tracy- Hide quoted text -

- Show quoted text -