Transpose

[Stuart Steven]

Hi there,

I have a row of cells that contain values. These are in
cells A1:E1 in Sheet1!.

How do I get the results of these cells into cells A1:A5
in Sheet2! using a formula?

I know i can copy and paste special using transpose, but
if the values in A1:E1 subsequently change, then I have to
update this again manually, rather than the computer doing
it automatically.

Is there a transpose worksheet function that I can use??

Many Thanks,

Stuart.

 

[Peo Sjoblom]

Select A1:A5 in Sheet2 with A1 as the active cell, then in the formula bar
put

=TRANSPOSE(Sheet1!A1:E1)

then enter it with ctrl + shift & enter

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Gord Dibben]

Stuart

Select A1:A5 on Sheet2

In A1 type in =TRANSPOSE(Sheet1!A1:E1)

Now hit CRTL + SHIFT + ENTER

Excel will place the curly brackets around it{} to designate as an Array
formula.

Gord Dibben Excel MVP