I am an inexperienced Excel user. I have a report in Excel using A1 through
A36000. I recorded the following macro. The macro works, but when I run it,
the new information uses the same row, covering up the previous information.
How can I get it to move down one row each time. (I want a1 through a20 to
go across a row at c1, then a21 through a40 to appear on the next row (c2),
etc.) If there is a way to get a macro to run through all 36000 cells at one
time, instead of running this macro over and over--that would be great too!

Sub Transpose()
'
' Transpose Macro
' Macro recorded 1/4/2005 by cstokley
'
' Keyboard Shortcut: Ctrl+t
'
Range("A1:A20").Select
Selection.Copy
Range("C1").Select
Range("C1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Range("A1:A20").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
Range("C2").Select
End Sub

--
Thanks in advance for your help,
Cathy S.