Hi,
Select the Cells that are place horozontally..
Select = Copy
Choose a new cell (Cell where you wish the vertical input to start
from)
then choose Paste Special = Transpose.
;)
--
woon san
------------------------------------------------------------------------
woon san's Profile:
http://www.excelforum.com/member.php...o&userid=28790
View this thread:
http://www.excelforum.com/showthread...hreadid=492565