software

How do I set a default data sort on a selected range in Exel. I select from
the collumn that the data need to be sorted on. But I have to select
decending all the time and select no header row all the time. All I want to
do is select the range to sort and hit OK.

Have a look in help index for OFFSET and
It might be best to define a name for the range to sort
insertgt;namesgt;definegt;name it anything you desire (sortrange)gt;in the refers to
box
=offset($a$2,0,0,counta($a:$a),6)--
Don Guillett
SalesAid Software

quot;cHrisquot; gt; wrote in message
...
gt; How do I set a default data sort on a selected range in Exel. I select
gt; from
gt; the collumn that the data need to be sorted on. But I have to select
gt; decending all the time and select no header row all the time. All I want
gt; to
gt; do is select the range to sort and hit OK.