Hi
I just want to know whether can u automatically sort the datas (ascending or descending)each time a record is added or deleted. If dis is possible only through macros could you please tell me how we do it? Thanx in advance.
Hi
I just want to know whether can u automatically sort the datas (ascending or descending)each time a record is added or deleted. If dis is possible only through macros could you please tell me how we do it? Thanx in advance.
do you want to add a button or just automatically sort when a new value is entered to the bottom?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Thnx Blake 7 for the spontaneous reply. Got to just automatically sort when a new entry is made at the bottom. For eg . if i hv 3 columns showing the Name, Designation and city's Name. Say...if i sort as per the name of the "city", each time I add a new record it should automatically get sorted alphabetically.
Last edited by buddy123; 09-05-2012 at 08:06 AM.
Copy and paste this into your worksheet. This is based on Name in Col A, Designation in Col B and City in C and sorting a to z
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks