ok, ive studied IT in college, but i never knew how to create an auto-sort macro. can anybody help me? please treat me as a beginner as i cant remember anything from college really.
what i need is to have "column A" automatically sort when the spreadsheet is opened. the column will contain movie names so it will include numbers and text, this column will have new movies added to it very often, so it would be a big help if it would auto-sort.
please if anyone could help i would be very grateful!
This is obviously a popular question.Originally Posted by DTox
Firstly, consider that no updates take place whilst the book is closed, there is little point to sorting the Sheet on 'open'.
You might be better to sort after each (major) update of items, or selectively at will. (the reason for that is the time taken by a sort would not be something you would wish to endure on each Worksheet calculation).
You could set a button (or a menu item) to perform the sort on a click.
To code such a sort, Tools, Macros, Record new macro, select all data (the 'all-data' button is to the left of 'A' and above the '1' in the column/row headers)
Data, Sort, (headers?), column A and sort.
Stop the recording and add a button.
View, Toolbars, Control Toolbox, first icon is toggle Design (Exit Design) mode.
in Design, select a button, and click-drag to place, size, shape, and colour etc, then Rightmouse (the button) and View Code
Copy the recorded macro's code into the button, and adjust as required.
Exit design mode and test.
(of course, save and save-as at various points)
hth
---
I'm a noob so take this with a grain of salt but what it sounds like to me is that you want to create a database not a spreadsheet. You can sort to your hearts content with Microsoft Access rather than spend hrs of programming in Excel with just the click of a mouse.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks