Results 1 to 4 of 4

Toggle Sort by selecting column (row, not header) or cell in table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Toggle Sort by selecting column (row, not header) or cell in table

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find Row OR Column Header for a cell in a two way table WITHOUT VBA
    By militiamc in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 03-31-2015, 02:23 AM
  2. Replies: 0
    Last Post: 02-16-2015, 04:54 PM
  3. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  4. [SOLVED] Extract the column header given the row header and highest value in a subset of a table
    By pguarino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2013, 02:05 AM
  5. Selecting a column range based on a value in header row
    By Ad83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2012, 05:29 PM
  6. Replies: 3
    Last Post: 05-17-2009, 04:31 AM
  7. Addressing Table cell using column header
    By munzer1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2007, 03:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1