Lovelylou79
New Member
- Joined
- Sep 4, 2017
- Messages
- 37
Hi Excel Experts!
I am trying to manipulate a multi staff timesheet for easy data entry and I've reached the point of the coding that is way beyond my vba abilities and am hoping for some help.
The timesheet can cover between 1 week to 1 month of data, dates of the month are at I21:AM21.
Each staff has 4 rows under these dates, consisting of Hours (Row22), Salary Code(Row23), Start and Finish Times (Rows24/25).
Staff names are in Column A in line with their matching hours.
What I would like to do is group/sort any staff that have duplicate shifts worked, matching Date, Hours, Code, Start and End times. Is this possible at the multi cell level? I have some codes that can do this based on a single cell, rather than a range of cell.
Any help would be greatly appreciated.
I am trying to manipulate a multi staff timesheet for easy data entry and I've reached the point of the coding that is way beyond my vba abilities and am hoping for some help.
The timesheet can cover between 1 week to 1 month of data, dates of the month are at I21:AM21.
Each staff has 4 rows under these dates, consisting of Hours (Row22), Salary Code(Row23), Start and Finish Times (Rows24/25).
Staff names are in Column A in line with their matching hours.
What I would like to do is group/sort any staff that have duplicate shifts worked, matching Date, Hours, Code, Start and End times. Is this possible at the multi cell level? I have some codes that can do this based on a single cell, rather than a range of cell.
Any help would be greatly appreciated.