Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated sort button
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated sort button
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated sort button
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated sort button
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated sort button
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating some sort of button that will take you to a new worksheet | New Users to Excel | |||
Button to sort a range, and sorting 12 columns | Excel Worksheet Functions | |||
Create a sort button? | Excel Discussion (Misc queries) | |||
Making a button to sort | Excel Worksheet Functions | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) |