Hello,
I am working on a document for a co-worker who isn't very tech-savvy. I have a two-column list on the third worksheet of the attached workbook. I would like to figure out a way to sort this list by clicking a button located in a cell (somewhere around D10). However, I want to avoid macros if at all possible. If not, what other ways are there to make it easy for a non-tech-savvy person to sort the list without using a macro?
Thank you.
how would you expect to click a button and sort without using vba?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
You have already built-in the solution! Because the data is already AutoFiltered, you can sort by using the AutoFilter pull-down.
Gary's Student
The "Sort & Filter" really is very straightforward.Originally Posted by Brkenarrow
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Jakobshavn and BB1972,
Thank you for your replies. The co-worker I'm working on this document for is 65 years old and had never turned on a computer until less than a year ago. I've tried explaining the Sort & Filter function to her, but I end up getting several calls later in the day with questions about how it works.
If she is a novice, then a macro is a good option. Just set her up with a button on the worksheet linked to a sort macro. All she would need to do is push the button.
Thank you for your help. I looked up how to make macros and buttons and I have the form figured out. Thank you much!
Thanks for helping your co-worker. If you need any help in getting and macro to work, update this question.
I am working on a computer that runs Windows 7 and MOffice 2007. From what I can gather she is running a computer with Windows XP and MOffice 2003. Will the macros that I create be compatible with her software?
Last edited by Brkenarrow; 09-12-2012 at 09:36 AM.
Excel 2007 has a new Sort Method, but the older (compatable) sort method is also available. You can create a sort routine that will run on both machines.
I've got very little experience with macros. How would I do this?
I have attached a sample in .xlsm format.
I am unable to see the code that you used with that macro. If I save the workbook in .xlsm format, will the macros be compatible with Office 2003 or do I need to change the code as well?
You can save the file in .XLS format (97/2003 compatible) and the macro will still be contained within it, so your co-worker should be able to use the file.
Hope this helps.
Pete
Pete_UK and Jakobshavn, thank you both for your patience and help!
Well, I didn't do very much, but thanks for feeding back.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks