Autopopulated Resource Calendar with Start and End dates

Hello

I appear to have deleted my original post whilst trying to add a link / attachment.
So apologies if this seems repeated.

What I am trying to do is create a Resource / Holiday planner for a new project I am working on. I want to be able to input a range of holiday dates ("From" and "To") and have rheum automatically populate a calendar. I had a couple of attempts but then decided to seek help / tutorial. I discovered "demo calendar" on the forum (great work whoever produced it) but I am trying to find a way to adapt it so that it includes the range of leave rather than having to enter each individual day. If that makes sense?

I've uploaded a link to the workbook (the last 3 sheets are the ones) Also in the other tabs I have the resource summary and manual entry for Holidays and Working Days. As a sideline if anyone has some advice on how to link them all together somehow I'd love to learn.

Thanks

Pauly

https://wetransfer.com/downloads/365...9061706/9def1b