View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excell 2007: How to arrange cells in a column file alphabetically?

The simplest thing is to re-sort every so often but others may offer you a
VBA solution
best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Vince" wrote in message
...
How can I arrange the data straight down in a column arrange
alphabetically??
For instance I enter the name of all my business contacts in a cell, how
could I make it so that every time I enter a new name, it will file it
alphabetically? Thanks much