I have some data, and half the time I wish to view the rows as sorted by column A, and half the time by column B.
Is there an easy way to easily switch between these two views of the rows, perhaps via two sheets that reference the same set of rows?
Or a one or two click flip between the two sort orders?
You can use one or two macro(s) for this task (maybe it is enough a recorded macro…)
Its just two mouseclicks to sort on this or that, so what??