Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Realtime Data Update Sorting
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Realtime Data Update Sorting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel realtime network update from source workbooks | Excel Discussion (Misc queries) | |||
Copy of realtime data. | Excel Worksheet Functions | |||
realtime list sorting/data exraction | Excel Worksheet Functions | |||
Realtime Automatic sorting of data in rows in new work sheet | Excel Worksheet Functions | |||
extract data from a realtime updated cell | Excel Discussion (Misc queries) |