software

I take data of temperatures and at the bottom I use the formula to find the
maximum temperatures for each column of my spreadsheet, which has about 150
columns. Once I get the maximum temperatures I then physically write all the
temperatures down and then I type them in on another spreadsheet that
summarizes the temperatures on what you would call a summary sheet. How can
I eliminate having to handwrite these temperature down? Can I put these max.
temperatures directly on the summary sheet?
Thanks,
Kim
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 specialgt;values 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: www.excelforum.com/member.php...oamp;userid=15101
View this thread: www.excelforum.com/showthread...hreadid=498265Is their a way to copy data that's going horizontal and pasting it vertically?
Thanks,
Kimquot;swatsp0pquot; wrote:

gt;
gt; Assuming your formula for finding the max in each column is in row 100
gt; on sheet1, on sheet2 (your summary sheet) simply use the formula:
gt;
gt; cell A1 =sheet1!A100
gt;
gt; and copy this across 150 columns (therefore, B1=sheet1!B100, etc.).
gt; You can now apply any desired formulas to this range (average, sum,
gt; etc.)
gt;
gt; Of course, you could also do a copy/paste specialgt;values if the data is
gt; not dynamic (you won't be changing any numbers in the data range).
gt;
gt; Does this work for you?
gt;
gt; Bruce
gt;
gt;
gt; --
gt; swatsp0p
gt;
gt;
gt; ------------------------------------------------------------------------
gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; View this thread: www.excelforum.com/showthread...hreadid=498265
gt;
gt;

I tried and I had to cut and paste, but it removed the data from my
spreadsheet. How can I keep my data from being removed. If I copy/paste I
get #REF! in my cells.
Thanks,
Kimquot;Kimquot; wrote:

gt; Is their a way to copy data that's going horizontal and pasting it vertically?
gt; Thanks,
gt; Kim
gt;
gt;
gt; quot;swatsp0pquot; wrote:
gt;
gt; gt;
gt; gt; Assuming your formula for finding the max in each column is in row 100
gt; gt; on sheet1, on sheet2 (your summary sheet) simply use the formula:
gt; gt;
gt; gt; cell A1 =sheet1!A100
gt; gt;
gt; gt; and copy this across 150 columns (therefore, B1=sheet1!B100, etc.).
gt; gt; You can now apply any desired formulas to this range (average, sum,
gt; gt; etc.)
gt; gt;
gt; gt; Of course, you could also do a copy/paste specialgt;values if the data is
gt; gt; not dynamic (you won't be changing any numbers in the data range).
gt; gt;
gt; gt; Does this work for you?
gt; gt;
gt; gt; Bruce
gt; gt;
gt; gt;
gt; gt; --
gt; gt; swatsp0p
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=498265
gt; gt;
gt; gt;

I figured out how to keep my data after I cut/paste when I close my
spreadsheet if I don't save changes it will be there. I can't figure out how
to go from horizontal to vertical when copying data.
Thanks,
Kimquot;Kimquot; wrote:

gt; I tried and I had to cut and paste, but it removed the data from my
gt; spreadsheet. How can I keep my data from being removed. If I copy/paste I
gt; get #REF! in my cells.
gt; Thanks,
gt; Kim
gt;
gt;
gt; quot;Kimquot; wrote:
gt;
gt; gt; Is their a way to copy data that's going horizontal and pasting it vertically?
gt; gt; Thanks,
gt; gt; Kim
gt; gt;
gt; gt;
gt; gt; quot;swatsp0pquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Assuming your formula for finding the max in each column is in row 100
gt; gt; gt; on sheet1, on sheet2 (your summary sheet) simply use the formula:
gt; gt; gt;
gt; gt; gt; cell A1 =sheet1!A100
gt; gt; gt;
gt; gt; gt; and copy this across 150 columns (therefore, B1=sheet1!B100, etc.).
gt; gt; gt; You can now apply any desired formulas to this range (average, sum,
gt; gt; gt; etc.)
gt; gt; gt;
gt; gt; gt; Of course, you could also do a copy/paste specialgt;values if the data is
gt; gt; gt; not dynamic (you won't be changing any numbers in the data range).
gt; gt; gt;
gt; gt; gt; Does this work for you?
gt; gt; gt;
gt; gt; gt; Bruce
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; swatsp0p
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=498265
gt; gt; gt;
gt; gt; gt;

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

Hope this helps.

quot;Kimquot; wrote:

gt; Is their a way to copy data that's going horizontal and pasting it vertically?
gt; Thanks,
gt; Kim
gt;
gt;
gt; quot;swatsp0pquot; wrote:
gt;
gt; gt;
gt; gt; Assuming your formula for finding the max in each column is in row 100
gt; gt; on sheet1, on sheet2 (your summary sheet) simply use the formula:
gt; gt;
gt; gt; cell A1 =sheet1!A100
gt; gt;
gt; gt; and copy this across 150 columns (therefore, B1=sheet1!B100, etc.).
gt; gt; You can now apply any desired formulas to this range (average, sum,
gt; gt; etc.)
gt; gt;
gt; gt; Of course, you could also do a copy/paste specialgt;values if the data is
gt; gt; not dynamic (you won't be changing any numbers in the data range).
gt; gt;
gt; gt; Does this work for you?
gt; gt;
gt; gt; Bruce
gt; gt;
gt; gt;
gt; gt; --
gt; gt; swatsp0p
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=498265
gt; gt;
gt; gt;


In addition to checking the 'transpose' box when doing Copy/Paste
Special... select Paste: Values. This will paste the contents of the
cell instead of the formulas (which may result in the #ref error).

Good Luck

Bruce--
swatsp0p------------------------------------------------------------------------
swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
View this thread: www.excelforum.com/showthread...hreadid=498265Thanks for all your help these shortcuts will save me lots of time.
Thanks,
Kimquot;swatsp0pquot; wrote:

gt;
gt; In addition to checking the 'transpose' box when doing Copy/Paste
gt; Special... select Paste: Values. This will paste the contents of the
gt; cell instead of the formulas (which may result in the #ref error).
gt;
gt; Good Luck
gt;
gt; Bruce
gt;
gt;
gt; --
gt; swatsp0p
gt;
gt;
gt; ------------------------------------------------------------------------
gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; View this thread: www.excelforum.com/showthread...hreadid=498265
gt;
gt;