Hello @itslesley1698, You can add more entries to the worktops cells by extending the range of your schedule. Here's how: Manual Method: If you're working with a manual schedule, simply insert new rows in the worktops section to add more tasks or data. Adjust Formatting: Ensure that any formatting (borders, colors, etc.) applied to the existing cells is extended to the new rows for consistency. Combo Box Method: If you’re using the Combo Box method, ensure that the data validation or linked cell ranges include the newly added rows. If you’re following along with the tutorial, double-check that any formulas or conditional formatting rules are updated to cover the extended range. Let me know if you need further help! Regards ExcelDemy
@KasperFeddern8 ай бұрын
It doesnt change in method 3 when I change month?
@exceldemy20068 ай бұрын
Dear, Thanks for sharing your difficulties with us. When you change a month from the combo box, the system does not change. If it does not change the dates accordingly, ensure you have used the formula correctly. Also, check that the combo box formula is: =B4. Follow these: 1. Choose cell C9 and insert the following formula: =DATE(B7, B4, 1) 2. Later in cell D9, insert the following formula: =C9 + 1 3. Next, drag the Fill Handle icon to cell AG9. However, the weekend color does not change dynamically when a month changes. Don't worry! We have improved the file in this case. When a month is over, remove all the previous entries and start newly for the new month using Data Validation. Please check the following: www.exceldemy.com/wp-content/uploads/2024/05/Use-of-Combo-Box-to-Create-an-Enhanced-Monthly-Schedule.gif Conditional Formatting Rules: =IF(WEEKDAY(C9) = 1, TRUE, FALSE) You can download the workbook: www.exceldemy.com/wp-content/uploads/2024/05/Kasper-Feddern-SOLVED.xlsm