SilverSN95
11-16-2009, 02:33 PM
Hi, I'm looking for help on a problem that is probably very common but I can't seem to find what I am looking for...
I would like to be able to insert a string into an existing excel table by alphabetical order ascending by column (think insertion sort). If the table is filled, create a new column and place the last element of the order there once sorted.
I'm a newbie with VBA and so I'm not sure what the easiest way to do this would be. Given nothing else, I would just put all of the strings in an array plus the new string to be added, sort that, and overwrite the old table with the contents of the sorted array, but I don't want to write code for something VBA may already do very easily.
Any suggestions or examples would be great, thanks.
I would like to be able to insert a string into an existing excel table by alphabetical order ascending by column (think insertion sort). If the table is filled, create a new column and place the last element of the order there once sorted.
I'm a newbie with VBA and so I'm not sure what the easiest way to do this would be. Given nothing else, I would just put all of the strings in an array plus the new string to be added, sort that, and overwrite the old table with the contents of the sorted array, but I don't want to write code for something VBA may already do very easily.
Any suggestions or examples would be great, thanks.