chaitanya2106
New Member
- Joined
- Jul 8, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
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.