Good night,
I started interning in an office where my boss asked me the following:
"I'm going pass to you the sales KPIs, for you automate the dashboards generation"
From what I understand ... the office uses a website to generate various reports in "Excel Binary Sheets". My boss takes these data and assembles a dashboard (he copies the data from the binary sheet and paste it to the file where the dashboards are). But he wants to stop using that Ctrl + C, Ctrl + V and do something more automatic.
I have a little knowledge of macro and absolutely no knowledge about VBA. But I think I'd have to do this automation using them. Am I right?
If yes, could someone indicate any online material to assist me?
If not ... Is there any more practical method to do this?
Thanks in advance, and sorry for the bad english
I started interning in an office where my boss asked me the following:
"I'm going pass to you the sales KPIs, for you automate the dashboards generation"
From what I understand ... the office uses a website to generate various reports in "Excel Binary Sheets". My boss takes these data and assembles a dashboard (he copies the data from the binary sheet and paste it to the file where the dashboards are). But he wants to stop using that Ctrl + C, Ctrl + V and do something more automatic.
I have a little knowledge of macro and absolutely no knowledge about VBA. But I think I'd have to do this automation using them. Am I right?
If yes, could someone indicate any online material to assist me?
If not ... Is there any more practical method to do this?
Thanks in advance, and sorry for the bad english
