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
Bookmarks