Home

Rollup calendar for business sub-units.

%3CLINGO-SUB%20id%3D%22lingo-sub-799137%22%20slang%3D%22en-US%22%3ERollup%20calendar%20for%20business%20sub-units.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799137%22%20slang%3D%22en-US%22%3EI%20have%20a%20requirement%20to%20provide%20some%20kind%20of%20a%20dash%20board%20or%20gantt%20type%20'master%20calendar'%20that%20can%20be%20used%20as%20a%20quick%20glance%20to%20see%20the%20schedules%20of%20all%20the%20business%20sub-units.%20The%20data%20is%20setup%20so%20that%20each%20business%20sub-unit%20has%20their%20own%20excel%20sheet%20within%20one%20workbook%20where%20each%20business%20sub-unit%20has%20their%20respective%20tasks%20arrayed%20along%20a%20'horse%20blanket'%20calendar.%20I%20would%20like%20to%20create%20a%20'master%20horse%20blanket'%20where%20each%20sub-units%20tasks%20are%20visible%20on%20a%20single%20sheet%20for%20quick%20reference%20for%20management.%20I'm%20thinking%20this%20way%20management%20can%20see%20how%20resources%20are%20deployed%20against%20a%20specific%20task%20on%20each%20day%20of%20the%20FY%20at%20a%20quick%20glance.%20I'm%20fairly%20certain%20this%20can%20be%20done%20in%20excel%20but%20I'm%20struggling%20with%20finding%20an%20example%20that%20I%20can%20work%20from.%20Does%20anyone%20have%20advice%20on%20how%20I%20might%20be%20able%20to%20do%20this%20or%20correct%20my%20vision%20of%20how%20I%20might%20do%20something%20like%20this%3F%20Thanks.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799137%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
Not applicable
I have a requirement to provide some kind of a dash board or gantt type 'master calendar' that can be used as a quick glance to see the schedules of all the business sub-units. The data is setup so that each business sub-unit has their own excel sheet within one workbook where each business sub-unit has their respective tasks arrayed along a 'horse blanket' calendar. I would like to create a 'master horse blanket' where each sub-units tasks are visible on a single sheet for quick reference for management. I'm thinking this way management can see how resources are deployed against a specific task on each day of the FY at a quick glance. I'm fairly certain this can be done in excel but I'm struggling with finding an example that I can work from. Does anyone have advice on how I might be able to do this or correct my vision of how I might do something like this? Thanks.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies