Automating Task Scheduling in Excel using VBA

[ibra1212]

Hello,
I’m working on a project management tool in Excel where I need to automate the task scheduling process using VBA. I have a list of tasks with start dates, durations, and dependencies. How can I use VBA to automatically update the start and end dates of tasks based on these dependencies? Ideally, when the start date or duration of a task changes, it should automatically adjust the subsequent dependent tasks. Any suggestions or examples would be highly appreciated!

 

[6StringJazzer]

This can be very complicated, which is why there is Microsoft Project. It's possible depending on the level of complexity you need.

I could help with this but I would have to have your file. Do you have a way to share it using a cloud file sharing service, like Google Docs, Dropbox, etc.?

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Creating Dynamic Gantt Charts in Excel using VBA - OzGrid Free Excel/VBA Help Forum

https://www.mrexcel.com/board/threads/automating-task-scheduling-in-excel-using-vba.1263591/ Hi everyone, I’m trying to create a dynamic Gantt chart in Excel using VBA for a project management assignment. I have task details such as start date, end date,…

forum.ozgrid.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.