Sorting irregular data Preferably with VBA

**daymo** · 11-03-2011, 08:21 AM

I have a daily timesheet which is generated using a macro. Some of the staff have 1 shift and some 2, there is also other information on the sheet which relates to each member of staff and their work day (see attached) is there a way of sorting this data by the start of the 1st shifts time?

Thanks

**arlu1201** · 11-03-2011, 08:29 AM

What do you mean by start of the 1st Shifts time? Can you cite an example using your attached file?

**daymo** · 11-03-2011, 08:34 AM

Sure, sorry.

If you look at F&B Commis 3 they are due to start at 8:00 and finish at 11:30 (the 1st shift) and then start again at 12:00 and finish at 21:30 (2nd shift)

When sorting the data I would like F&B commis 3 to to be sorted using 8:00 as the start time (ie the start of her 1st shift) and not 12:00 (the start of her second shift)

Allan R, on the other hand only has one shift that day 14:00 - 00:00 so would like 14:00 to be used to sort him.

Thanks again

**arlu1201** · 11-03-2011, 08:36 AM

Ok. Thanks for the explanation. But when i look at the sheet, i see that all the columns are already sorted. So what problem are you facing?

**daymo** · 11-03-2011, 08:48 AM

I would like to be able to have it sorted so that we have the earliest start times at the top. In otherwords it would be
Krzystof (06.30)
Magda (07.00)
F&B Commis 2 (8.00)
F&B Commis 3 (8.00)
Helen (8.00)
Miguel (8.00)
Karina(9.30)
Natalie (11:30)
F&B Commis1 (12:00)
Allan (14:00)
Charlotte (14:00)
Jekaterina(14:30)
Sam (17:00)
Gergely (17:30)

Or as per the attached

Thanks

Simon

**Steffen Thomsen** · 11-05-2011, 07:46 AM

Suggestion!

Try having data from on person on a single row, with as few possible data in each column

Like

Please Login or Register  to view this content.

Then data below.
If you create your file in this way it's a lot easier to sort and filter the way you like.

Steffen Thomsen

**Alf** · 11-05-2011, 05:05 PM

Perhaps this file and macro could be of help to you?

Alf

**daymo** · 11-06-2011, 03:51 PM

Thanks guys for your help.

Alf, that's just the ticket - works perfectly. thank you.

**Alf** · 11-06-2011, 04:55 PM

Ok, glad you liked it. The first file is build so you can see what happends. If you think it fits your need and after testing it a bit you could try this file.

It works in the same way as the first file but it clears all info on sheet2 and copies the sorted info from sheet3 (yes I renamed it back to sheet3) back to sheet1 and then clears all info on sheet3.

If this takes care of your problem don't forget to mark the tread solved and if you like to give me a pat on the back click on my scale icon and give a rating to my solution.

Alf