I have a table that can be sorted two different ways. In a perfect world, I'd like to be able to hide the two sort columns.
While doing this, I'd like to have the ability to sort the table by choosing which order to use via cell reference.
As you can hopefully see below, I have two sort columns (C&D) and I'd like to use the cell reference in cell F1 to tell the table which column to use as it's sort order.
While doing this, I'd like to have the ability to sort the table by choosing which order to use via cell reference.
As you can hopefully see below, I have two sort columns (C&D) and I'd like to use the cell reference in cell F1 to tell the table which column to use as it's sort order.