( by Paul Machtolf )
I want to sort a named range everytime a value changes in the range. How do I do that automatically? I'm working on a iMac OS 10.6.8
You can use sort function in the same sheet or some other sheet, and call that named range in it, to get the sorted range every time you update value in that range.
Have a look at the following screenshot of 'Sheet1' of my Spreadsheet:
I have named the range "Sheet!B2:C9" as "myRange".
Screenshot of 'Sheet2':
And I have the following formula in Cell D1:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.