I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, I have to individually sort my required ranges. Since there are multiple types of data that share the same column I am not able to sort by column, also I have found sorting ranges by header is not a viable solution.
For example I need a way of performing the following actions.
Range: B3-C9, Sort By Column C, Sort: Z-A Range: H3-I9, Sort By Column I, Sort A-Z Range: H13-I19, Sort By Column I, Sort Z-A Range: N13-O19, Sort By Column O, Sort Z-A Range: N23-O29, Sort By Column O, Sort Z-A Range: T23-U29, Sort By Column U, Sort A-Z
Is it possible to create a script to to perform these actions with a minimum of clicks? I have a little experience writing scripts, but if someone could point me in the right direction on how to do it I would be very grateful. If however, someone has a template script with the functionality I'm after, I am sure I can modify it to my requirements.