Beau the dog
Board Regular
- Joined
- Mar 8, 2021
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I'm trying to create an automated vehicle maintenance planner and saw this online, but couldn't see how they achieved it. This isn't my final solution, but might get me closer. How did they automatically plot the 'X' based on the interval and start date for each vehicle (with no VBA)? I've entered the X's manually.
I'm trying to create an automated vehicle maintenance planner and saw this online, but couldn't see how they achieved it. This isn't my final solution, but might get me closer. How did they automatically plot the 'X' based on the interval and start date for each vehicle (with no VBA)? I've entered the X's manually.
13/12/2021 | 20/12/2021 | 27/12/2021 | 03/01/2022 | 10/01/2022 | 17/01/2022 | 24/01/2022 | 31/01/2022 | 07/02/2022 | 14/02/2022 | 21/02/2022 | 28/02/2022 | 07/03/2022 | 14/03/2022 | 21/03/2022 | 28/03/2022 | 04/04/2022 | 11/04/2022 | 18/04/2022 | 25/04/2022 | 02/05/2022 | 09/05/2022 | |||
Interval | Start | |||||||||||||||||||||||
Vehicle 1 | 6 weekly | 13/12/2021 | X | X | X | X | ||||||||||||||||||
Vehicle 2 | 8 weekly | 13/12/2021 | X | X | X | |||||||||||||||||||
Vehicle 3 | 8 weekly | 20/12/2021 | X | X | X | |||||||||||||||||||
Vehicle 4 | 12 weekly | 27/12/2021 | X | X |