+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Excel experts... (/showthread.php?tid=155177)
Excel experts... - bazookaman - 07-16-2013
...is there a way to save a custom sort?
I have an excel file with 24 columns and a couple thousand rows. We use it to make a catalog. Anyway, after editing it, we custom sort it the way we need to then save as a CSV. No muss no fuss. But what I'd really love to do is to save that custom sort setting. So every time someone edits it, they don't have to remember to custom sort using the headers Main Category first, the sub 1, then sub 2 etc. etc. etc. It would be nice to just hit one button and the custom sort is automagically applied. But i cannot find anywhere to do this. This seems like it would be a no brainer so Excel probably doesn't have a way to do it. Just thought i'd ask.
Re: Excel experts... - cbelt3 - 07-16-2013
Jeez.. I have no idea sort of recording a Macro. Sorry.... I think there used to be a way to do it, but it's been 'improved' out.
Re: Excel experts... - mrlynn - 07-16-2013
There are ways to do it, apparently depending on version:
http://excelusergroup.org/forums/t/1328.aspx
and other Q&A sites from Web search.
Sounds like recording a macro would work, too. You might need to select whole columns if your rows vary from one instance to another.
/Mr Lynn
Re: Excel experts... - Z - 07-16-2013
This might help ya - http://www.ehow.com/how_6942342_sort-columns-vba.html