I am looking for someone to automate excel. The automation will mostly be done in excel with final charts to be pushed to powerpoint.
What I am looking for is to have one excel template (instead of currently 2) with the first worksheet being a "dashboard". On the dashboard would be a list of command buttons that reflect each step in the instructions. The last step (or button) would be to "push" certain charts from excel into a powerpoint presentation.
There are 4 files attached. The instructions, two excel workbooks and a powerpoint. The 2 excel workbooks can be combined into one, matter of fact, I would prefer that. Each file ends with FWXX which FW stands for Fiscal Week and the XX is the week that the metrics were done. The files should keep the name with the FWXX so I know that these are the templates. Then I would save them as FW01, FW02 when the metrics are completed.
The instructions are step by step and easy to do, but VERY time consuming. It usually takes 4-8 hours per week to do this manually. I need all the steps (except the ones noted in the instructions) to be automated. You can use macros or VBA.
Please email me if you need further clarification.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4). CLEAR instructions within the code on what the codes does and how to change it if needed. The code notes must be WRITTEN CLEARLY and not in "technical terms". It was be easy for the owner of this tool to decipher.
Windows and Office 2000.