Use 'Paste Special' - at the bottom of the pop up there is a check box called
"Transpose".
This will switch from horizontal to vertical or vice-versa.

Hope this helps.

"Kim" wrote:

Is their a way to copy data that's going horizontal and pasting it vertically?
Thanks,
Kim


"swatsp0p" wrote:


Assuming your formula for finding the max in each column is in row 100
on sheet1, on sheet2 (your summary sheet) simply use the formula:

cell A1 =sheet1!A100

and copy this across 150 columns (therefore, B1=sheet1!B100, etc.).
You can now apply any desired formulas to this range (average, sum,
etc.)

Of course, you could also do a copy/paste specialvalues if the data is
not dynamic (you won't be changing any numbers in the data range).

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=498265