Hi, two things, this is a better implementation (workbook-level event):
2nd, I thought you had some understanding of VBA from the contents of the workbook, but never mind...
This code needs to go in the workbook code:
get there by pressing Alt+F11
on the left of the window that pops up there should be a project explorer (looks like folder tree)
find your workbook (looks like VBAPROJECT (NEW ALL ROOMS...)
open it with the + if not already open
open Microsoft Excel Objects folder if not already open
Double click "ThisWorkbook"
Paste code into here
Editing the functionality:
Sheets which effect a sort:
A line begins "Case sh.name", put the names of any sheet whose changes you want to force a sort of alpha roster into that list
Sort priority:
Three lines begin "Key" (1,2, & 3) change which one is A, B or C to define the sort priority.
HTH
Bookmarks