07-16-2013, 03:27 PM
...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.
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.