View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEE DEE is offline
external usenet poster
 
Posts: 250
Default auto format cell to enter data alphabet in column

I have 2 columns on my worksheet. 1st is alphabetical list of projects, 2nd
are the identifying project numbers. when i enter a new project name at the
top of the first column, i want it to enter directly into the correct
alphabetical cell in the column