Results 1 to 2 of 2

Adding a sorting button to a table to sort as desired

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Adding a sorting button to a table to sort as desired

    Hi,

    I have included a link to an example workbook:
    https://www.box.com/s/0bb182aa5ba0ed26b1ea

    I am trying to add a sorting button to an excel table so that when you click on any of the the column headers all of the data related to a name
    is sorted in the following order...

    Name = by forename A to Z
    Year = 2, 1 then Fn
    Class = Emerald, Gold, Ruby, Sapphire, Amber, Aqua, Crimson, Turquoise, Blue, Green, Purple, Red, Yellow
    SEN Stage = Statement, School Action+, School Action + (SALT), School Action, Initial Concern

    I have tried adding different filters, including the Excel Custom Sort function but can not figure out how to add a button or a way so that all you
    have to do is to is to click the column header.

    Any help or advice would be warmly welcomed,

    Regards,
    Matt
    Last edited by mj_bowen; 06-10-2012 at 11:48 AM.

Thread Information

Users Browsing this Thread

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

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