title: Excel dynamic calendar: bank holidays per country
body: <p>Morning all,</p>
  
  <p>Having a few issues with a project at the moment.</p>
  
  <p>I have 2 sheets, one listing a table of bank holidays in a dozen countries (Country eg. UK, Holiday eg. New Years day, Date eg. 01/01/2017) the second sheet is a 12 month calendar. selectedCell is a blank cell to the right of the holiday table and a little piece of VB pulls the date which is currently selected on the calendar. Ive then got an index formula to list the holidays on that selected day which then displays to the right of the calendar. </p>
  
  <p>There is also some conditional formatting on the calendar highlighting the day if there is a holiday for anyone listed in the table.
  point. Id like to have the country in a drop down above the calendar so that it 
  It could do with some refining and im not sure what else I can try at this just shows the bank holidays for the specified country and not all of them. Could someone point me in the right direction?</p>
  
  <p>Thanks so much in advance! <a href="https://i.stack.imgur.com/Ku9kB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ku9kB.png" alt="enter image description here"></a> <a href="https://i.stack.imgur.com/Ku9kB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UUOc8.png" alt="enter image description here"></a></p>