Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
how do I get data from one excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |