Hi to all
What I am trying to do is search the leave calendar (sheet APS), find those not on leave (blank or P (P is in white so not visible)) from the APS sheet, between the two dates specified on the Duty Picker sheet, and list them in on the duty Picker sheet.
I am not sure where to start.
Any assistance would be muchly appreciated.
I have attached the example workbook that I am working on.