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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

parag - 15 Jun 2006 00:37 GMT

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 ?

Reply to this Message

Biff - 15 Jun 2006 03:14 GMT

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

Reply to this Message

parag - 15 Jun 2006 21:33 GMT

thanks biff this helped alot and it works like a charm

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 ?

Signature

parag

Reply to this Message

Biff - 15 Jun 2006 22:29 GMT

You're welcome. Thanks for the feedback!

Biff

> thanks biff this helped alot and it works like a charm
>
[quoted text clipped - 15 lines]
> displayed automatically in sheet 2 (horizontal) can anyone please help me
> ?

Reply to this Message