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.
September 10, 2008 12:37 AM
September 10, 2008 2:57 AM