Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2022, 12:17 AM
Felix Asadu Felix Asadu is offline Using a code to sort out Data Windows 10 Using a code to sort out Data Office 2016
Novice
Using a code to sort out Data
 
Join Date: May 2022
Posts: 2
Felix Asadu is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-10-2022, 04:47 PM
BobBridges's Avatar
BobBridges BobBridges is offline Using a code to sort out Data Windows 7 64bit Using a code to sort out Data Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 05-11-2022, 01:07 AM
Felix Asadu Felix Asadu is offline Using a code to sort out Data Windows 10 Using a code to sort out Data Office 2016
Novice
Using a code to sort out Data
 
Join Date: May 2022
Posts: 2
Felix Asadu is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Using a code to sort out Data Sort Data rkeles Excel 6 02-04-2012 01:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft