#1
|
|||
|
|||
Using a code to sort out Data
Please Is there a code to be used to sort out data automatically? It could be a general sorting or sorting by Column D. Thank You
|
#2
|
||||
|
||||
Felix, I don't understand the question. You can sort the data in a worksheet based on the data in one column (D or whatever), but what do you mean by a "code"?
Wait, maybe the key word here is "automatically". Are you hoping for a way to tell a worksheet to resort itself, even after you've made changes to it? I suppose that's possible. But I've never heard of anyone trying to do it; the usual way is to make your changes to the worksheet, then re-sort the data manually. I've never tried it, but I guess you could write a program that is automatically executed every time you make a change to that worksheet. The program would first check to see whether any of the changes you'd made are in column D (or whatever column you're sorting on), and if that column is involved then do the sort. Seems to me that would be disruptive, though; you'd insert a new row, say, with a new value in col D, and instantly the row would be snatched away from your view and reappear somewhere else in the worksheet according to its sort value. I don't think I'd like it. |
#3
|
|||
|
|||
Thank you for your reply, I guess automatic sorting is what I was referring to.
But I understand and agree with all you've said. Thank you for your time though. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyphens in Sort Code not appearing in mail merged Word document | Joanne | Mail Merge | 4 | 11-12-2021 02:31 AM |
VBA sort table code | mikec | Excel Programming | 8 | 10-01-2013 04:37 PM |
Outlook Combobox Sort Code | lms | Outlook | 1 | 09-18-2013 09:56 AM |
sort data in excel | cabot | Excel | 1 | 08-17-2012 09:41 AM |
Sort Data | rkeles | Excel | 6 | 02-04-2012 01:31 PM |