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

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

In xl2003+, you can apply data|filter|autofilter to the range and use the
dropdown arrow to sort your data.

Debra Dalgleish has a technique at her site that adds invisible rectangles in
the headers and then sorts the data by that field when you click on one of those
rectangles.

http://contextures.com/xlSort02.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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

--

Dave Peterson

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

Jim,

I am interested in utilizing a macro to accomplish what I am trying to do.
Please let me know if you are still interested in helping me. Thanks

Brandon

"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