View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Judy Rose Judy Rose is offline
external usenet poster
 
Posts: 23
Default Setting a spreadsheet to auto sort data entry

Have a spreadsheet that is created each month to track the reappointment
applications for that month, there are 16 various stages the application
could be in and the number 1-16 is entered into column A. I want to be able
to set up the spreadsheet to auto sort based on the entry in Column A upon
update of the value.

Each case starts at 1, depending on its progress through the review process
would dictate the number value beyond 1, each time I update the record to
show progress I want my spreadsheet to automatically resort the rows of data
based on the updated value.

Is this possible.
--
Judy Rose Cohen