Hi all,

i have developed a Human resorces holiday spreadsheet to track holiday and sick days, there is a sheet for each month and a total page. my problem is that for the totals to work the name on row 8 on sheet 1 must match the same as row 8 on all other sheets. sorting a singular sheet causes issues.

what i require is a macro that when pressed will sort all sheets. the data i require to be sorted is in this range. "163 R x 41 C" and should be sorted on columb A. the headding size is 4 rows.

the current code i have be working on will sort a single sheet but not take into account the headings above and this will be sorted too.

(i have based the code i have on something i found on line and have tryed to modify it for my own use)

Formula: copy to clipboard 
Please Login or Register  to view this content.


Employee Absence 2015 Example.xlsm

attached is the document i have been working on, any help resolving this would be greatly appreceated.

Thanks

Turtlesrun