Auto sort in real time

[Bernard Jordan]

Is it possible to auto sort data so that changes update themselves i
real time without using VBA.
I have sorted a column of data in decending order but when I change
value in that column it does not update its self and re-arrange th
order of values automatically. Can I make it do that for me? I know ho
to create a macro that will re-apply the sort but a realtim
re-arrangement of data (like in Access) would be much better. Ca
anyone help me?

Many thanks
Bernard Jordan - Liverpool U

 

[Stephen Guine]

Bernard,

If you've already written the VBA, try putting it in
the "Change" section of the worksheet's VBA code. That
way after you update a cell, the re-sort will be
automatic.

Warmest regards,
Stephen K. Guine

 

[RagDyer]

If by data, you mean numbers, or formulas that yield numbers, this can be
done.

However, since you stipulated;
<<"without using VBA">>,
a formula must be used, and since a formula is used, you cannot enter data
into the formula cell itself to be sorted.
This means utilizing a "helper" column, perhaps right along side the actual
values column, where the sorting will take place and be displayed.
The original column of values will remain unchanged.

With data in A1:A50,

Enter this in B1 to sort *ascending*:
=SMALL($A$1:$A$50,ROW())

OR

Enter this in B1 to sort *descending*:
=LARGE($A$1:$A$50,ROW())

Adjust ranges as necessary and drag down to copy, or, if data is already
entered in column A, just double click the "fill handle".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


message Is it possible to auto sort data so that changes update themselves in
real time without using VBA.
I have sorted a column of data in decending order but when I change a
value in that column it does not update its self and re-arrange the
order of values automatically. Can I make it do that for me? I know how
to create a macro that will re-apply the sort but a realtime
re-arrangement of data (like in Access) would be much better. Can
anyone help me?

Many thanks
Bernard Jordan - Liverpool UK

 

[Bernard Jordan]

Thanks for your help, however I still need more help:

Rag Dyer - Your formula worked a treat but how do I get the informatio
in the column(s) next to the data that changes to stay in sequence, eg
If I had a row of information linked to the position of a race Positio
- Name

The Positions can be displayed 1-3 or 3-1 but the names don't move. Ca
I keep them in sequence?

Stephen Guine - Don't think you quite understood what I meant. I ca
record a macro that updates a sort and attach it to a button that I ca
press to re-sort the data. How do I get the VBA code from this macro t
go into the "change" section you refer to?

Cheers for the help so far.

Bernar

 

[Bernard Jordan]

*If by data, you mean numbers, or formulas that yield numbers, thi
can be
done.

However, since you stipulated;
<<"without using VBA">>,
a formula must be used, and since a formula is used, you cannot ente
data
into the formula cell itself to be sorted.
This means utilizing a "helper" column, perhaps right along side th
actual
values column, where the sorting will take place and be displayed.
The original column of values will remain unchanged.

With data in A1:A50,

Enter this in B1 to sort *ascending*:
=SMALL($A$1:$A$50,ROW())

OR

Enter this in B1 to sort *descending*:
=LARGE($A$1:$A$50,ROW())

Adjust ranges as necessary and drag down to copy, or, if data i
already
entered in column A, just double click the "fill handle".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Bernard Jordan >" <<[email protected]
wrote in
message Is it possible to auto sort data so that changes update themselve
in
real time without using VBA.
I have sorted a column of data in decending order but when I chang
a
value in that column it does not update its self and re-arrange the
order of values automatically. Can I make it do that for me? I kno
how
to create a macro that will re-apply the sort but a realtime
re-arrangement of data (like in Access) would be much better. Can
anyone help me?

Many thanks
Bernard Jordan - Liverpool UK

Rag Dyer - Your formula worked a treat but how do I get the informatio
in the column(s) next to the data that changes to stay in sequence, eg
If I had a row of information linked to the position of a race Positio
- Name

The Positions can be displayed 1-3 or 3-1 but the names don't move. Ca
I keep them in sequence?

Stephen Guine - Don't think you quite understood what I meant. I ca
record a macro that updates a sort and attach it to a button that I ca
press to re-sort the data. How do I get the VBA code from this macro t
go into the "change" section you refer to?

Cheers for the help so far.

Bernar

 

[RagDyer]

Even though we've been talking about sorting all along, the cells containing
the formula are *not* actually being sorted.
They're just displaying the contents of column A in the rank of the values
contained, equal to the row number that they (the formulas) are entered
into.
AFAIK, this can't be accomplished with text.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

message

*If by data, you mean numbers, or formulas that yield numbers, this
can be
done.

However, since you stipulated;
<<"without using VBA">>,
a formula must be used, and since a formula is used, you cannot enter
data
into the formula cell itself to be sorted.
This means utilizing a "helper" column, perhaps right along side the
actual
values column, where the sorting will take place and be displayed.
The original column of values will remain unchanged.

With data in A1:A50,

Enter this in B1 to sort *ascending*:
=SMALL($A$1:$A$50,ROW())

OR

Enter this in B1 to sort *descending*:
=LARGE($A$1:$A$50,ROW())

Adjust ranges as necessary and drag down to copy, or, if data is
already
entered in column A, just double click the "fill handle".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Bernard Jordan >" <<[email protected]>
wrote in
message Is it possible to auto sort data so that changes update themselves
in
real time without using VBA.
I have sorted a column of data in decending order but when I change
a
value in that column it does not update its self and re-arrange the
order of values automatically. Can I make it do that for me? I know
how
to create a macro that will re-apply the sort but a realtime
re-arrangement of data (like in Access) would be much better. Can
anyone help me?

Many thanks
Bernard Jordan - Liverpool UK

however I still need more help:

Rag Dyer - Your formula worked a treat but how do I get the information
in the column(s) next to the data that changes to stay in sequence, eg.
If I had a row of information linked to the position of a race Position
- Name

The Positions can be displayed 1-3 or 3-1 but the names don't move. Can
I keep them in sequence?

Stephen Guine - Don't think you quite understood what I meant. I can
record a macro that updates a sort and attach it to a button that I can
press to re-sort the data. How do I get the VBA code from this macro to
go into the "change" section you refer to?

Cheers for the help so far.

Bernard