Hi all,
I have 5 sheets in my workbook. The first sheet named ‘Subbie Compliance’ has 2 sorting functions. The first, Column D (Subbie’s name) sorts the names alphabetically. The second, Column ‘W’, has a ‘True’ or ‘False’ argument based on a Marlett checkbox in column ‘U’ which, when highlighted, marks the row as ‘Not in Use’. This second sort is in descending order, so the ‘Not in Use’ rows appear at the bottom of the sheet.
I have used the record macro function to record the following macro.

Please Login or Register  to view this content.

The cells D6:F50 are replicated on all 5 sheets.
The user only needs to fill these cells in the ‘Subbiecompliance’ sheet, as there is an auto-fill function in the remaining 4 sheets (‘Sheet2’, ‘Sheet3’, ‘Sheet4’, ‘Sheet5’) based on the cells in the ‘SubbieCompliance’ sheet.
These cells D6:F50, in Sheets 2, 3, 4 & 5, are sorted when the ‘Subbie compliance’ page is sorted.
However, what is needed is for the remaining cells (B6:C50,G6:O50) in ‘Sheets 2, 3, 4 & 5 to also be sorted. At this point these cells remain in their original positions.
This is where I’m having problems. I need help including these cells in the above code.
I have searched the forums and have found nothing specific to my needs.

Any help would be greatly appreciated.