Hi, I am trying to figure out how to sort a table column by descending order [or ascending order if its already in descending order] by clicking either the column "Header" (my actual header is a hidden row because the names are not user friendly, so the user will see the row above the table and this is what they will be double clicking. The caveat here is that the table has columns with number, alpha-numberic, all alpha, currency, and dates... does anyone know how to accomplish this? I could also link a (Click) button to each cell header if that is easier but am trying to avoid that because then will need to edit each macro according to the data in that particular column. The example workbook attached is only some of the columns... in the actual workbook its around 70 columns with 10-15k rows so trying to keep this as lightweight as possible
Thanks for any help!
Bookmarks