how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2

hi there i am really in a delima here i want to copy cell C1:C10 (which is a
formula and displayed vertically) into SHEET 2 in a horizontal format,
so at the end if i make any changes in sheet 1(vertical) it should be
displayed automatically in sheet 2 (horizontal) can anyone please help me ?

Hi!

Try this:

=INDEX(Sheet1!$C1:$C10,COLUMNS($A:A))

Copy across to 10 cells.

Biff

"parag" <u23036@uwe> wrote in message news:61c85a62d213d@uwe...
> hi there i am really in a delima here i want to copy cell C1:C10 (which is
> a
> formula and displayed vertically) into SHEET 2 in a horizontal format,
> so at the end if i make any changes in sheet 1(vertical) it should be
> displayed automatically in sheet 2 (horizontal) can anyone please help me
> ?

thanks biff this helped alot and it works like a charm

Biff wrote:
Hi!

Try this:

=INDEX(Sheet1!$C1:$C10,COLUMNS($A:A))

Copy across to 10 cells.

Biff

Hi there i am really in a delima here i want to copy cell C1:C10 (which is a
formula and displayed vertically) into SHEET 2 in a horizontal format, so at
the end if i make any changes in sheet 1(vertical) it should be
displayed automatically in sheet 2 (horizontal) can anyone please help me ?

--
parag

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

You're welcome. Thanks for the feedback!

Biff

"parag via OfficeKB.com" <u23036@uwe> wrote in message
news:61d353e4a833c@uwe...
> thanks biff this helped alot and it works like a charm
>
> Biff wrote:
> Hi!
>
> Try this:
>
> =INDEX(Sheet1!$C1:$C10,COLUMNS($A:A))
>
> Copy across to 10 cells.
>
> Biff
>
> Hi there i am really in a delima here i want to copy cell C1:C10 (which is
> a
> formula and displayed vertically) into SHEET 2 in a horizontal format, so
> at
> the end if i make any changes in sheet 1(vertical) it should be
> displayed automatically in sheet 2 (horizontal) can anyone please help me
> ?
>
> --
> parag
>
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200606/1

How can I do the opposite, Horizontal to vertical?