Display Sort Order

I need for a cell in a sheet (in this case, ...cell F1) to display the Sort Order of a list.
Currently, users can see the Sort Order if I turn on the filtering (dropdowns), ...However some user will not notice the small sort arrows,
...and also the sort/filter dropdowns do not appear when the list is printed. (which the typical way users will see/use this list)

In other words, ...I want something like this:...To appear like this when printed:
Notice that in both images, I would like cell F1 to display the Sort.
So if the list was resorted by Last Name, ....Cell F1 would display: LastName

Notes:
The sort "Order" (direction) is not really needed, just the field name.
The list will probably never be sorted on more than one column at a time, ...so no need to worry about that either

If a VBA solution is acceptable then try this workbook. In it I've changed the data to a table and added a formula in cell I5 that could be anyplace on the sheet either hidden or out of sight. The code can also tell you if the sort is ascending or descending if you like.28970158.xlsm

If you look at your sample data, you will see that the FirstName is the first column which is sorted in ascending order though the sorting is applied on the LastName field.
In reality no such names exist and if you replace your dummy data with your actual data, it will work without an issue.

Featured Post

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.