theterminator
Wise Old Owl
Hi,
Suppose I’m in an organisation where there is a hierarchical structure where there are Regions in metro cities under which Operating Units (OU) operate in smaller cities.
Suppose I publish daily a different report for each OU. Write now I only send dynamic content which only contains text with some formatting for which I got a VBA code but the module is password protected so I don’t know what’s written & also I’m an intermediate excel user but a newbie to VBA programming. I want to extend this functionality to include dynamic charts & graphs for each OU. Something like a dynamic dashboard. And I can email to all the OUs using outlook.
How can I do this? I need a solution which can work on excel 2013 onwards. I’ve seen many videos regarding this but none cater to my needs.
Suppose I’m in an organisation where there is a hierarchical structure where there are Regions in metro cities under which Operating Units (OU) operate in smaller cities.
Suppose I publish daily a different report for each OU. Write now I only send dynamic content which only contains text with some formatting for which I got a VBA code but the module is password protected so I don’t know what’s written & also I’m an intermediate excel user but a newbie to VBA programming. I want to extend this functionality to include dynamic charts & graphs for each OU. Something like a dynamic dashboard. And I can email to all the OUs using outlook.
How can I do this? I need a solution which can work on excel 2013 onwards. I’ve seen many videos regarding this but none cater to my needs.