SPREADSHEET DATA

[Kim]

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

[swatsp0p]

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 special>values if the data is not dynamic (you won't be changing any numbers in the data range).

Does this work for you?

Bruce

[Kim]

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

[Kim]

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

[Kim]

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

[Gizmo63]

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

[swatsp0p]

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

[Kim]

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