Complex/Multi Level Grouping/Sorting like items

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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
I've come to realise the above makes absolutely no sense, and this is why no one has responded. I do apologise.
I have been working on a solution and am breaking down each function individually rather than attempting to complete it all in one big hit.
Thanks to those that have had look.
 
Upvote 0

Forum statistics

Threads
1,215,553
Messages
6,125,483
Members
449,233
Latest member
Deardevil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top