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