I want to make the bellow table dynamic with the following options:
- A dropdown list that contains many products (product 1, 2, ...etc).
- A dynamic calendar cell that enables me to choose any date.
- Link the date cell and the product cell to the whole table so that when I move between products or choose another date the table becomes blank and I can add new checkmarks to each product independently.
New Microsoft Excel Worksheet.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
2 | Manufacturing Daily Checklist (F1) | |||||||||||||||
3 | Date | 27/9/2022 | Time | |||||||||||||
4 | Model | Product 1 | ||||||||||||||
5 | NO. | PROCESS | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | ||
6 | 1 | Machine 1 | ✓ | ✓ | ✓ | - | - | - | - | - | - | - | - | - | ||
7 | 2 | Machine 2 | - | - | ✓ | ✓ | ✓ | - | - | - | - | - | - | - | ||
8 | 3 | Machine 3 | - | - | - | - | - | - | - | - | - | - | - | - | ||
9 | 4 | Machine 4 | - | - | - | - | ✓ | ✓ | - | - | - | - | - | - | ||
10 | 5 | Machine 5 | ✓ | - | - | - | - | - | - | - | - | - | - | - | ||
Sheet1 |