Good Morning Everyone,
I am new to this community and do not know too much about Excel programming. In the attached spreadsheet, my goal is to have the calendar tabs ('Staff', 'Craft', and any new calendar that is added) auto-populated from the 'Overview' tab. However, I only want the persons name to display on the calendar if they will be on vacation (denoted by a blue cell with a 'V'). Currently, the calendars are filled by the adjacent table which creates a need to input information twice. A colleague recommended VBA coding to do this. Does anyone have experience with this or know how to solve my problem? I appreciate any and all help!
Bookmarks