Excel Challenge  5,625 pts. Let's say that I have an Excel
spreadsheet that contains a long list in column A. How might I
go about taking every 40 items in column A and moving it to its
own column? For example, A1:A40 remains in column A; A41:80 gets
moved to column B and so on. I'm not looking for a thought
process but rather code samples, if available. ASKED: September
10, 2008  12:37 AM UPDATED: September 10, 2008  2:57 AM  Answer
Wiki   This Excel Macro should do the trick for you.  <pre> Dim
i As Integer Dim j As Integer i = 2 j = 41 Do Until Range(“A” &
j).Value = “” Range(“A” & j & “:A” & j + 39).Select Range(Chr(i
+ 64) & “1″).Select j = j + 40 i = i + 1  Discuss This Question:
   Send me notifications when members answer or reply to this
question.  REGISTER or login:  Forgot Password?  Forgot Password
Your password has been sent to: