Results 1 to 6 of 6

Multi-macro, button to sort by multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2016
    Location
    The Moon, Milkyway Galaxy
    MS-Off Ver
    2013
    Posts
    19

    Cool Multi-macro, button to sort by multiple columns

    Hello programmers!

    How to create a macro that will:
    1. Copy Starting Sheet (A1:L2000 All formulas w/ some cell formatting.)
    2. Create New Workbook
    3. Paste the Values & Formatting of Starting Sheet to New Workbook, Sheet 1
    4. Sort the sheet by "Column Title 1" then by "Column Title 2" then by Column Title 3." This sheet will have headers so the sort can be done by name, also the columns are static so we could use H1 then by K1, then by E1.



    I know it's a bit much, but I hope to some of you Jedis out there it's a simple Death Star to stifle.

    Best,

    DemRulesDoe
    Last edited by DemRulesDoe; 10-28-2016 at 06:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to sort columns instead of using the sort button
    By Hyflex in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2016, 10:20 PM
  2. [SOLVED] sort columns with macro button
    By sirdon in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-24-2013, 11:22 PM
  3. [SOLVED] Macro button to sort columns
    By sirdon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 08:45 PM
  4. [SOLVED] Compare, Match, and sort multi columns
    By BeyondInvisible in forum Excel General
    Replies: 8
    Last Post: 12-13-2012, 08:12 PM
  5. Sort Button that does not sort Balance Columns
    By hasancem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 10:31 AM
  6. match and sort by multi columns
    By nachi in forum Excel General
    Replies: 2
    Last Post: 07-22-2011, 05:56 AM
  7. macro to split and sort to multi worksheets
    By r_aggie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2007, 05:52 PM

Tags for this Thread

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