Results 1 to 20 of 20

VBA Code to Sort a list with column header activating the code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-05-2010
    Location
    Lakewood, IL
    MS-Off Ver
    Excel 2016
    Posts
    389

    VBA Code to Sort a list with column header activating the code

    I have a problem that I think is best solved with VBA code. I have a table (attached) that I want to sort by clicking the Year Date at the top of each column B6 through G6. I found this article https://trumpexcel.com/sort-data-vba/ but I can get it to do any thing adapting this code.

    I have provide the results corrected sort from Largest to Smallest in Columns I through M with the cell I want to activate the code on a "click" in green just for clarity but the real table will have the dates all the same color. I also what to sort the "Unit" B column alphabetically.
    Attached Files Attached Files
    Last edited by Bobbbo; 11-04-2019 at 05:20 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Activating in cell drop down list creates a VBA code execution error
    By VBA Grunt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2021, 03:27 AM
  2. [SOLVED] VBA code to sort a list by WBS code
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-20-2018, 10:58 AM
  3. Big List Sort. Not Enough Memory. Help Run my Code. Or help fix or change code Please :)
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 47
    Last Post: 06-08-2017, 06:56 AM
  4. VB Code Custom Sort then Insert Header
    By Intalzky in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 11:06 PM
  5. Sort column list by header
    By suprchic66 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2014, 11:06 PM
  6. [SOLVED] Use the column Header to column letter code to set range in Macro
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2013, 11:06 AM
  7. Code to Sort Data by Clicking on Header Row Cells
    By Coop913 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-07-2009, 01:24 PM

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