G
grovesy
Hi there, I have been using excel for year to make simple spreadsheets
but now I have been tasked with creating a sort of task time line bu
have no idea how!
I want the dates down the side (How would you exclude weekends??)
Then I want a button where the user can "add a task" the user wil
enter a task name, start date and effort, ie length of time required t
complete.
Excel will then automatically "block" fill the releivent time period.
But to make things even more complicated, if the user adds a task tha
has a start date the starts in the middle of another task (Say the
entered a holiday as a task) then I would want the task that will b
effected to be automatically split in two (So that you can see that th
task is started before the holiday then continued after) Also all task
after that would have to have their start dates automatically shifte
down to allow for this new task.
I know this is asking a lot but if anyone can point me t
tutorials/code/examples etc I would be most grateful.
Cheer
but now I have been tasked with creating a sort of task time line bu
have no idea how!
I want the dates down the side (How would you exclude weekends??)
Then I want a button where the user can "add a task" the user wil
enter a task name, start date and effort, ie length of time required t
complete.
Excel will then automatically "block" fill the releivent time period.
But to make things even more complicated, if the user adds a task tha
has a start date the starts in the middle of another task (Say the
entered a holiday as a task) then I would want the task that will b
effected to be automatically split in two (So that you can see that th
task is started before the holiday then continued after) Also all task
after that would have to have their start dates automatically shifte
down to allow for this new task.
I know this is asking a lot but if anyone can point me t
tutorials/code/examples etc I would be most grateful.
Cheer