Hey all,
Hoping I can get some help here. I created a generic calendar with year (c3) and month input (c4). In each row and column there is another drop down for manger (starting with b10) and to the right (in c10) is a list dependent on b10. This goes all the way through the calendar. What I'd like to do is have all the contents cleared but not deleted when a new month is selected. Drop down lists go are from B10 to O92. Lists are housed in a sheet titles List of Employees. Thanks a ton for any help!
Hoping I can get some help here. I created a generic calendar with year (c3) and month input (c4). In each row and column there is another drop down for manger (starting with b10) and to the right (in c10) is a list dependent on b10. This goes all the way through the calendar. What I'd like to do is have all the contents cleared but not deleted when a new month is selected. Drop down lists go are from B10 to O92. Lists are housed in a sheet titles List of Employees. Thanks a ton for any help!