Jim and dave,

Thanks for your quick responses.
Seeing that there is no other way, I would be interested in using a macro.

"Jim Thomlinson" wrote:

There is nothing built in to do what you want but you could do it with a
macro. If you are interested in persuing that just reply back...
--
HTH...

Jim Thomlinson


"Bwells" wrote:

Does anyone know if there's a way to automate the sort function in the column
of a table so that it updates automatically based on new inputs. I have the
table hidden and I do not want to have to hit the sort button everytime at
the top of the column. Please help. Thanks