VBA to change the format of a range of cells based on dates.

  • Hello,

    I am currently attempting to make a calendar function for a manager in my office. She would like it so that when when staff input their time off that is formats a overall calendar view to show when they are off. with each member of staff down the left and the dates shown across the top.

    I had thought to loop through all the names on the employee tracker list to filter and amend the cells but I am having trouble making it work, I will post what I have been trying below. I apologise for the mess, i am still getting to grips with VBA. On the "2017" sheet I have put the dates adjacent to each person.

    Any help would be appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!