Need help with Custom Sort macros

Hi there,

I'm new here, and know next to nothing about VBA. My workplace, a military fire department, uses an Excel workbook for our annual shift schedule. The workbook is divided into 26 worksheets, one for each pay period in the year, and our personnel roster includes fields (columns) for Name, Duty Position, Location, and Shift Rotation. My goal is to put several buttons on each worksheet that will allow a user to sort the roster by any of those four categories. Three of them are a simple A-Z sort, but for Location sorting I need to sort by Location, then by Position, then by Name. This is the default sorting.

I've tried a numer of different VBA code solutions that I've found, but I can't seem to tailor them to my needs. Recording a macro for each button hasn't worked either, and I don't know why (but I think it's because when I run the macro on another sheet, the macro only affects the first sheet--not sure).

Additionally, the worksheets are designed to be printed out and contain a lot of info about staffing levels each day. I've attached a screenshot (names removed).

Can anyone walk me through this?


Many thanks,

-Kevin

[Edit: Workbook sample is attached now, screenshot removed]

Hello Metorks,

Welcome to the forum!

It would be a huge help if you could post the workbook. There is a lot of formatting that can effect how the code should be written.

Since you are new, I don't think you can post a workbook yet. You can either email me a copy and I will post it or you can upload it to a public file share and post the link.

(Got it. Attached in original post.)

[deleted to reduce thread clutter]