Nifty Show/Hide & Export to Excel - MS Access
The download contains a working example of a pop-up form which allows you to show and hide various columns in a datasheet. It also has the ability to export data from the datasheet to Excel. Once you have selected the columns you want to export you have the option of applying a filter and sort to the columns and then this filtered and sorted data will be exported to Excel.
More Info about the Product on my Website HERE:-
Show/Hide & Export to Excel