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
|