rbscott1989
New Member
- Joined
- Apr 25, 2019
- Messages
- 9
Good morning everyone,
I am working on designing a schedule for equipment in mycompany. I have recently learned about aGannt chart and have been able to build one in my workbook. When a place a start and stop date by a pieceof equipment that time is then blocked off. Here is my problem, often times that same piece of equipment will beused multiple times in a week/month and definitely throughout the year. Right now I have a drop down that breaks itdown by month. However, I need to alsobe able to view the schedule for the entire year. As is right now only one date range can bescheduled for each piece of equipment.
So if truck1234 is scheduled for May 15 2019 - May 20 2019,I cannot schedule anything more.
Ideally I want to be able to go and add an unlimited amountof entries for truck1234 throughout the whole year. Can this be done?
Thanks all in advance!
I am working on designing a schedule for equipment in mycompany. I have recently learned about aGannt chart and have been able to build one in my workbook. When a place a start and stop date by a pieceof equipment that time is then blocked off. Here is my problem, often times that same piece of equipment will beused multiple times in a week/month and definitely throughout the year. Right now I have a drop down that breaks itdown by month. However, I need to alsobe able to view the schedule for the entire year. As is right now only one date range can bescheduled for each piece of equipment.
So if truck1234 is scheduled for May 15 2019 - May 20 2019,I cannot schedule anything more.
Ideally I want to be able to go and add an unlimited amountof entries for truck1234 throughout the whole year. Can this be done?
Thanks all in advance!