Displaying data sort order as descriptive text in footer

[Jay]

I have a spreadsheet that will be printed and sorted (in
different orders) frequently. It's an inventory list.
While Excel allows me the capability to sort the data by
various columns I don't see a way (by function, field,
etc) to grab a descriptive string describing that sort
order (e.g., the text "Serial Number, Lease Expiration
Date").

What I'd like to do is put this descriptive text in the
footer of the document so that sort order is properly
indicated to the user without the user having to change
the footer manually to match their own desired sort order.

Can anyone tell me if this can be done and how? I've
never programmed anything for Office but I am a VB
programmer if that's what it takes. If so, then some
nudges in the right direction or some sample code would
be extremely appreciated!!!! THANKS. - Jay

 

[Charlie]

Jay

One possible way would be to create several macros' each
with a different sort order. While creating the macro for
sort one, continue to the menu, view, header/footer, click
custom footer and type in sort1, click ok and stop the
macro. Do this for each sort macro with a different text
in custom footer. Then create a Form in VBA with the sort
options. The Form will make it easy to sort and provide a
footer with the right dialog.

Charlie O'Neill