1. S

    VBA to automatically populate rolling rota - Help?!

    HI, I'm looking for a VBA solution to automatically populate an on call rota please. The rota should be filled according to the following rules: Only 1 staff member for each day Staff member can't be on 2 consecutive days weekdays are allocated separately from weekend days. This is to ensure...
  2. R

    Count nonblank cells except with certain criteria

    Hi, I'm trying to create a new rota for my workplace [Google Sheets – image below- Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4). I'm currently using...
  3. M

    Staff rota

    Hi All, Say I have a restaurant and need certain staff on different tasks each night. We try to make it so that each member of staff perform each job at some point in the week. I want to avoid one member of staff being in the pair that for example washes pots 3 days a week when everyone...
  4. S

    Excel Staff Rota

    I have a staff rota and want to input a date to show staff who are available to be called for cover. I have tried Index Match and Vlookup but my Excel experience falls short. I have an example spreadsheet but cant see how t upload?
  5. J

    IF functions with weekdays

    Hi guys. I have a Rota sheet that I'm doing some work on. I have an if function in to retrieve the data from the master Rota for each user if they are in that day. The issues I'm having is the coloum beside it. I want to put a formula in that says for example if b4 is not empty weekday is...
  6. T

    Highlight repeat words if within the next 2 or 3 consecutive rows and ignore blank cells? there. I've searched on this forum and others for thisone but I can't seem to find it. I am by no means an expert with Excel so Iwould really appreciate some help. I am responsible for our rota at work. I have recently changed it to Excel fromWord to try and help me...
  7. R

    Conditional formatting to fill in blank cells based on adjacent cell

    I'm quite rusty with excel so could use some help. I've created a staff rota spreadsheet which tells people which department they'll be working in that day, and have a separate sheet that counts up this information to tell the management team how many people will be in any given department per...
  8. T

    Selecting names from one workbook and placing them in another workbook.

    Hello experts, I am hoping that this is not too big an ask? I have a workbook called weekend planning, I was wondering if it would be possible that when I add a date into the cells highlighted then it will cross reference with my engineering rota workbook and workout who is on shift for that...
  9. C

    Rota help needed with breaks

    Struggling to make this work for me, probable cause - complete novice. I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks. I cheated a little and did the...
  10. B

    Rota deducting lunch if shift over so many hours

    So I want to get a total amount of hours worked in a day, which takes away lunch of 30 mins if someone works 6 or more hours, what formula do I use? Cheers
  11. W

    Auto-populate ongoing rolling rota by date

    Hi All, My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off. There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the...
  12. B

    Counter formula for work rota

    Im trying to set up a rota in excel but need some help. I need a formula that will check if a cell contains letter E or L (early shift or late). Then at the bottom of table will add them up and display so i know how many people on each shift. Table will be peoples names down column A, then going...
  13. H

    Rota tool, criteria met.

    Hi Guys, I have an issue that i can't seem to get my head around. I have a tool that i use to determine how many staff i require to open my restaurant. With the manager starting at 07:00. The tool adds the following for each staff member starting; 07:00 = 1 08:00 = 0.75 09:00 = 0.5 10:00 =...
  14. Q

    conditional formatting

    Hi all, I am trying to make a cell highlight in red if there are more than 1 condition present. The table below represents a work rota and also a holiday planner underneath. The initials of each employee are entered into the rota for each day they are at work. If they are on a rest day (RD)...
  15. L

    Rota times

    I'm trying to do a works Rota with let's say 3 people starting at 6 oclcok 5 at 7 oclcok and 1 at 8 o'clock but I want to know the formula . Also I want it as 06:00 07:00 08:00 on the Rota so it's easier to see. 1/3/18 2/3/18 3/3/18 etc Person 1 06:00 Person 2...
  16. R

    Formula or VBA code to revert back to a formula if manually entered data is deleted

    Hi all, So basically I have created a spreadsheet to use as a rota calendar for work. I have used / changed a formula I found on another spreadsheet to automatically populate my calendar with the rota for the year, based on which rota is selected and the start date for that rota and the year...
  17. P

    Rota Form Help

    Hi I have a workbook that I have created for a rota. It runs for the full year with data being selected using a drop down. what im trying to do is create a userform which asks for the date, and based upon the date entered it searches through each worksheet (jan to dec) and displays the name of...
  18. T

    Rota start/finish times including a break

    Hi, I have an ongoing project where I fill in cells of scheduled work times for staff that results in displaying their start and finish times, sometimes over 7 hours and always 8 hours or more this will include a scheduled unpaid break so this time needs to be deducted. My current formula does...
  19. B

    VBA Index / Match?

    Hi, I have 2 worksheets, one called "Rota" & one called "Day Plan". Within the Rota worksheet, I have dates between B2:AE2, a list of names between A5:A7,A9:A17,A19:A24,A26:A35 and then various values between B5:AE35 Within the Day Plan worksheet, I have the same names but between...
  20. H

    add and remove rows for 5 week rota

    Hi Guys, I have a rota that has the entire year form 26/12/16 - 31/12/17 in column A from A2 down. I have a row from each date with shift codes and staff names. What I would like to achieve is to only show 5 weeks of rota and any given time. Is there a VBA to hide rows and unhide. So for...

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
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 "".
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