List sorting and rearranging

[NightJumper]

Ok so i havent programmed in excel before but Im trying to take a list and make it so it takes the list and sorts the list alphabetically and then breaks it up into columns for each letter (and numbers) so it does something like this:

takes this:
B
D
3
D
B
A
C

Into:
3
A
B
B
C
D
D

and then into this:
3 A B C D
B D

If there is already something like this then sorry, not sure where to start looking.

[pike]

play around with

Please Login or Register  to view this content.

[NightJumper]

ok and where would i go about putting this, I havent used macros before so not quite sure how to do this

[teylyn]

NightJumper,

if you're starting out with VBA, this is probably not the easiest challenge to begin with.

See this thread for links to VBA tutorials and resources

http://www.excelforum.com/excel-work...additions.html

You need to copy the code pike provided into a standard module in the VB Editor:

- copy the code above, but start with the line below Sub testOne()
- in Excel click Tools - Macro - Macros
- enter testOne into the macro name box
- click create
- paste the code into the window that opens

Now you can run the code via Tools - Macro - Macros