Changing from Rows to Columns
 

On sheet one I track attendance. In Column A are names. In Columns
D-AH (are the dates 1-31). Row 1 Date header; Row 2, Day text (as
determined by row 1); Row 3 the total attendance of the day.

So D3:AH3 have the totals. I want to put the information in Row 3 on
another sheet, but in a single column so I can print a report on a
single sheet of paper. Is there a way to do it quickly without
referencing each individual cell manually?


--
RayH
------------------------------------------------------------------------
RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647
View this thread: http://www.excelforum.com/showthread...hreadid=564044

Changing from Rows to Columns
 

Hi!

Select the range D3:AH3
Goto EditCopy
Navigate to the other sheet and select the first cell where you want the
data to appear.
Goto EditPaste SpecialTransposeOK

Biff

"RayH" wrote in message
...

On sheet one I track attendance. In Column A are names. In Columns
D-AH (are the dates 1-31). Row 1 Date header; Row 2, Day text (as
determined by row 1); Row 3 the total attendance of the day.

So D3:AH3 have the totals. I want to put the information in Row 3 on
another sheet, but in a single column so I can print a report on a
single sheet of paper. Is there a way to do it quickly without
referencing each individual cell manually?


--
RayH
------------------------------------------------------------------------
RayH's Profile:
http://www.excelforum.com/member.php...o&userid=36647
View this thread: http://www.excelforum.com/showthread...hreadid=564044

Changing from Rows to Columns
 

Thank you.


--
RayH
------------------------------------------------------------------------
RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647
View this thread: http://www.excelforum.com/showthread...hreadid=564044

Changing from Rows to Columns
 

You're welcome!

Biff

"RayH" wrote in message
...

Thank you.


--
RayH
------------------------------------------------------------------------
RayH's Profile:
http://www.excelforum.com/member.php...o&userid=36647
View this thread: http://www.excelforum.com/showthread...hreadid=564044