Realtime Data Update Sorting

[devada1]

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

ALSO IT IS MANDATORY THAT THE SORTED OUT DATA DOESN'T UPDATE IN TH
COLUMN/ROW ITSELF AND GIVE THE VALUES,BUT INSTEAD IT KEEPS ITS PAREN
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 TH
SORTING TO BE AUTOMATICALLY DONE.('R' ONLY).i.e.,THE RIL ROW SHOUL
AUTOMATICALLY COME TO SECOND PLACE WHEN THE DATA CHANGES IN THE RI
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.
THAN

 

[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