Will Pay for the Help of an Excel Expert on my Staff Rota...

[wisematthew]

Dear Excel Community,

I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff.

I have an Excel template, into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his Elves.

We then manually input the initials of the employees who will cover each shift resulting in a rota which tells us who is working and when.

What it does not do allow me to do automatically is generate individual hours sheets for each staff member based on where their initials appear in each time slot. Currently, we are manually creating these sheets by reading the initials off each time slot and inputting the shift into an hours sheet.

Can anyone create a automatic process of creating hours sheet for me? Just get in touch and I will send examples.

Kind regards,
Matthew

 

[ZAX]

Hi matthew and welcome on board,
I would really like to help u but i dont understand what u want exactly to do...A sample data or more explanation would be so helpful.
ZAX

 

[wisematthew]

Hi ZAX,

Thank you for your reply. May I send you an email with the relavant excel docs?

I am at if you would prefer to send me an email to which I will reply.

Kind regards,
Matthew

 

[VoG]

It is against the forum rules to offer payment for services, specifically " users shouldn't post questions offering compensation in exchange for solutions. If you are looking for consulting services, please refer to our Consulting Services. "

In addition, please do not advertise your e-mail address on this forum.

 

[wisematthew]

Hi Zax,

Your private message box has apparently exceeded it's limit.

 

[Busclas]

Could you not just create a pivot table from the master sheet with a filter of the initials, then just change your filter and print that?

 

[MARK858]

Or just a lookup...

Excel Workbook
	A	B
1	David	10/1/2013 10-12
2	Mark	10/1/2013 10-12
3	Mark	10/1/2013 16-18
4	David	11/1/2013 12-3
5	David	11/1/2013 15-17
6	John	10/1/2013 10-17
7	Mark	12/1/2013 12-4
8	David	14/1/2013 8-4
9	John	11/1/2013 8-12
10	John	11/1/2013 4-6
11	Mark	14/1/2013 8-13
12	John	12/1/2013 9-4
Sheet1

Excel Workbook
	A
1	Mark
2	10/1/2013 10-12
3	10/1/2013 16-18
4	12/1/2013 12-4
5	14/1/2013 8-13
Sheet2

A2 copied/dragged down and making sure the formula is entered with CTRL+SHIFT+ENTER and not just Enter.

 

[ZAX]

Hi Zax,

Your private message box has apparently exceeded it's limit.

Hey,
I emptied my pm inbox now but it seems like u already got ur answer! um ready to help u anyway!!
ZAX

 

[wisematthew]

I don't think pivot tables will work but I have attached the example files here:

My Christmas Grotto Staff Roster Needs the Help of an Excel Expert...

 

[VoG]

OK, you have broken multiple rules hee so his post is clos3ed.