Gantt Chart - Dependencies

Alexie0830

New Member
Joined
Oct 5, 2017
Messages
1
Hi Everyone,

We are trying to recreate MS Projects functionality in XLS and running into a few issues (weak in VBA).

We've created Gantt Chart which has multiple dependencies (tasks cant begin unless previous task finishes or task must complete if other task finishes).

To add additional complexity - the task can not be executed (go live) if it falls into certain weeks of the month. (Closing week - Accounting calendar).

Example:

Closing - every 4th week of the month (for 5 business days) - during this time no task can go live (it could be executed but not released)

- Task 1 (main)
- Task 2 (dependent on Main)

Option A: Task 2 must finish if Task 1 finishes
Option B: Task 2 cant start unless Task 1 finishes.

Has anyone tried to do this in XLS?

Any insight will be greatly appreciated.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,109,011
Messages
5,526,263
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top