Hi
When sorting using the standard "DATA - SORT" menu in excel2013, it pops up the data sort box.
The "Sort On" field lists values, cell color, font color, cell icon.
Would be great if you could also list Absolute value as an option.
Is there any way to do this in VBA?
Of course it may require creating a form or object or something.
Alternatively, as a quick solution, is there a way to easily create a macro (and then assign to a button on custom toolbar) which does a sort on absolute value, but without actually creating a column of absolute values I.e. the macro should not need to create a column of ABSOLUTE values and then sort on that column. It should use the values in the specified range.
Any thoughts?
Bookmarks