SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello peeps.
I have a workbook with several sheets that contain recommendation actions. I have already created a dashboard but would also like a Gannt Chart on another sheet that auto populates anytime an action is added to any sheet (there are 25 recommendation sheets with actions listed in each one). I've got the conditional formatting working for start and due dates and hoping there is a formula to collect the aforementioned data (actions entered) over a range of other sheets (to avoid duplication, or having to update two places if there are changes!)?
Any help would be appreciated.
Ta muchly!
I have a workbook with several sheets that contain recommendation actions. I have already created a dashboard but would also like a Gannt Chart on another sheet that auto populates anytime an action is added to any sheet (there are 25 recommendation sheets with actions listed in each one). I've got the conditional formatting working for start and due dates and hoping there is a formula to collect the aforementioned data (actions entered) over a range of other sheets (to avoid duplication, or having to update two places if there are changes!)?
Any help would be appreciated.
Ta muchly!
Last edited:
