I have a table with a colmun that has restricted values to Yes/No. Default
entry is No. Is it possible to have the table sort itself, so that when this
cell is changed to Yes, the table sorts itself and puts the rows with Yes in
that cell at the bottom of the table? Obviously this is very easy to do by
just sorting it, but as this entry changes a lot and the workbook is shared
amongst several people, it would be easier if it could be done automatically,
rather than manually.

thanks