Hey this might be kind of answered already but I still didn’t manage to figure out how I can automatically sort data descending on the last column of a table that I fill up every month. The problem I got is that I want a dynamic table that I fill numbers in rows, for every month of the year for 10 persons and it changes by descending order. Should I use a macro? should I use formula?
this is a link of my table
What you describe can be described by term “relational database”, where the order of record hasn’t significance. This is best handled by Base.
Of course, you may use a macro to do that in Calc, too (or even in Writer, if you’re creative)… but I suppose that using a tool specifically suited for the job is the best. In Base, you may apply sorting to the dataset either on table level, or on view level as you need (including dynamically).
I don’t know how to use base at all but thnx for the answer.
I ve found some usefull info here but when I use the 1st (with copy paste) and I try to run it at args1(0).Value = oRange.AbsoluteName I cant figure how to use the range I want because the I don’t know how to pick values.
Not automatic, but easy.
Defining a range for you data Menu/Data/Define Range,
you can then define a Menu/Data/Sort with the options preserved for above range.
To use it:
1-Click in the Data range or Menu/Data/Select Range
2-Menu/Data/Sort [Ok]
1 Like