Rota in Excel - Formula for creating daily overview based on shifts times

Hi Ali

Many thanks for the prompt response.

I have slimmed down the attached rota to show a 2 week block on the first tab with 20 staff on it. On the second tab is the format I would like the daily sheet to appear, columns are headed with the shift time and then the name of that person/s working that particular shift. I am only looking for those particular shift times as headed on tab 2, other information you will see such as "OFF", "H" or "R#" can be ignored.

As requested on tab 2 I have created a mock up for 06/05/19.

I look forward to response, and thanks again for your help.

Jamie (pokerjam)

Try the attached.
There is a combobox on "Daily" that is populated from the dates on "Rota"
Right click "Daily" tab on small menu select "View Code" (this open the code window of sheet).
The code is almost self explanatory and expandandable by adjusting parameters to suit.
There is no sheet formula to get corrupted.
torachan.