Hello,
At work I created a template to filter specific data (From an excel data pull) and compile it in to graphs and tables. This has saved my department 100's of man hours, as the data pull is enormous and was sorted and reported manually before I arrived on the scene This template I created has some 40,000+ sums involved.
Once the reports are completed they are required to be put in to a word document (Multiple docs, one for each graph). I am looking to automate this too.. I don't know any VBA and no real experience using Macros. Can anyone recommend a good place to start? Maybe some sort of comprehensive guide? I have looked online and could only find conflicting information!
Any help would be appreciated.
Thank you.
At work I created a template to filter specific data (From an excel data pull) and compile it in to graphs and tables. This has saved my department 100's of man hours, as the data pull is enormous and was sorted and reported manually before I arrived on the scene This template I created has some 40,000+ sums involved.
Once the reports are completed they are required to be put in to a word document (Multiple docs, one for each graph). I am looking to automate this too.. I don't know any VBA and no real experience using Macros. Can anyone recommend a good place to start? Maybe some sort of comprehensive guide? I have looked online and could only find conflicting information!
Any help would be appreciated.
Thank you.