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" wrote in
message ...

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