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

--
devada
-----------------------------------------------------------------------
devada1's Profile: http://www.excelforum.com/member.php...fo&userid=3049
View this thread: http://www.excelforum.com/showthread.php?threadid=50145