Try this:

=INDEX(Sheet1!$F:$F,COLUMNS($A:A))

This can be entered *anywhere*, and copied to the right, and return your
Column F values from Sheet1.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Shannon" wrote in message
...
I need help figuring out how to copy a formula horzontally on one tab
while
the source data resides on a different tab vertically. Can't use
copy/paste
special/transpose, because the links have to be dynamic. Gord Dibben
suggested using the INDEX function. But this only worked when I was
working
on the extreme left column. However, if I try to reference a column, say
column F, which is 5 columns over the formula starts looking at the 5th
data
point down in the column. So If I want to start the formula in F:1, it
will
actually start in F:5. Is there a way to change that? Or is there
another
function that would do the job better?
Thanks Everyone.