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
?