Rota Form Help

[Pret441]

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 the persons for each entry in the dropdown box for that day. cells b5:b12 is the names of the person, c4:AG4 is each day and the options for the dropdown list are "Fire", "Deputy","Sweep" and "Sweep 2". If the entry RDO is in the cell I would like an error message indicating that the person is "on Registered day off, please recheck details" - thanks very much in advance

 

[Pret441]

Fire Marshall Cover A Ground for 01/9/18 to 30/09/18

NAME

01/09/2018

02/09/2018

03/09/2018

04/09/2018

05/09/2018

06/09/2018

07/09/2018

08/09/2018

09/09/2018

10/09/2018

11/09/2018

12/09/2018

13/09/2018

Rachel Arthur

Susan Bissell

RDO

Gillian Black

Sweep

Deputy

Michael Callaghan

Fire

Deputy

Deputy

Vikki Forsyth

Deputy

Fire

Gillian Kirkland

Sweep 2

Caitlin Shields

RDO

Barry Taylor

Column1

Deputy

Fire

<tbody>
</tbody><colgroup><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup>