Realtime Data Update Sorting

[devada1]

I WANT TO KNOW HOW WE CAN SORT A DATA BY COLUMNS/ROWS OF A DYNAMICALLY CHANGING REAL TIME DATA.

ALSO IT IS MANDATORY THAT THE SORTED OUT DATA DOESN'T UPDATE IN THE COLUMN/ROW ITSELF AND GIVE THE VALUES,BUT INSTEAD IT KEEPS ITS PARENT ROW/COLUMN IDENTITY INTACT.

SUPPOSE

COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
RIL 856 852 859 850 9
SAT 743 740 756 738 18
INFY 3126 3112 3148 3122 26


IF SORTED('R' ONLY) IN DECREASING ORDER WILL BE

COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
INFY 3126 3112 3148 3122 26
SAT 743 740 756 738 18
RIL 856 852 859 850 9


BUT AFTER A WHILE THE VALUES CHANGE IN A REALTIME ATMOSPHERE,I WANT THE SORTING TO BE AUTOMATICALLY DONE.('R' ONLY).i.e.,THE RIL ROW SHOULD AUTOMATICALLY COME TO SECOND PLACE WHEN THE DATA CHANGES IN THE RIL COLUMN.

COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
INFY 3129 3112 3148 3122 26
RIL 866 852 869 850 19
SAT 748 740 756 738 18


PLEASE ADVICE.
THANQ

[Mike Fogleman]

It depends on how your data is updated. If I assume it is a web query being
refreshed periodically, then I would put the sort routine immediately
following the refresh. If it is an external link, then you could use the
Worksheet_Change Event (). Does this help?

Mike F
"devada1" <devada1.21oh7y_1137331801.126@excelforum-nospam.com> wrote in
message news:devada1.21oh7y_1137331801.126@excelforum-nospam.com...
>
> I WANT TO KNOW HOW WE CAN SORT A DATA BY COLUMNS/ROWS OF A DYNAMICALLY
> CHANGING REAL TIME DATA.
>
> ALSO IT IS MANDATORY THAT THE SORTED OUT DATA DOESN'T UPDATE IN THE
> COLUMN/ROW ITSELF AND GIVE THE VALUES,BUT INSTEAD IT KEEPS ITS PARENT
> ROW/COLUMN IDENTITY INTACT.
>
> SUPPOSE
>
> COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
> RIL 856 852 859 850 9
> SAT 743 740 756 738 18
> INFY 3126 3112 3148 3122 26
>
>
> IF SORTED('R' ONLY) IN DECREASING ORDER WILL BE
>
> COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
> INFY 3126 3112 3148 3122 26
> SAT 743 740 756 738 18
> RIL 856 852 859 850 9
>
>
> BUT AFTER A WHILE THE VALUES CHANGE IN A REALTIME ATMOSPHERE,I WANT THE
> SORTING TO BE AUTOMATICALLY DONE.('R' ONLY).i.e.,THE RIL ROW SHOULD
> AUTOMATICALLY COME TO SECOND PLACE WHEN THE DATA CHANGES IN THE RIL
> COLUMN.
>
> COMPANY CMP OPEN HIGH(H) LOW(L) R=H-L
> INFY 3129 3112 3148 3122 26
> RIL 866 852 869 850 19
> SAT 748 740 756 738 18
>
>
> PLEASE ADVICE.
> THANQ
>
>
> --
> devada1
> ------------------------------------------------------------------------
> devada1's Profile:
> http://www.excelforum.com/member.php...o&userid=30492
> View this thread: http://www.excelforum.com/showthread...hreadid=501456
>