SPREADSHEET DATA
 

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

SPREADSHEET DATA
 

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

SPREADSHEET DATA
 

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

SPREADSHEET DATA
 

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,
Kim


"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

SPREADSHEET DATA
 

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,
Kim


"Kim" wrote:

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,
Kim


"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

SPREADSHEET DATA
 

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

SPREADSHEET DATA
 

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: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=498265

SPREADSHEET DATA
 

Thanks for all your help these shortcuts will save me lots of time.
Thanks,
Kim


"swatsp0p" wrote:


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: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=498265