We are looking for a Freelancer to write an Excel Macro to assist with our client reporting. So, to take our raw data, prepare it and auto populate our reporting templates.
Here is the current process:
1. Multiple reports are collected (all with slightly different layouts), and all in CSV format.
2. We edit the data in the reports to ensure Excel recognizes all figures. For example some cost data is shown as $4,500.00 - excel does not recognize this as a number, so we have to remove the comma.
3. Data is then put into pivot tables.
4. Data from pivot tables is then manually copied into a reporting template.
- Data sets may vary from report to report, so the macro must be able to adjust dynamically.
- Upon acceptance of the project, we can send through examples of each step of the work.
Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions
29 freelancers are bidding on average $351 for this job
Hi, I have lots of experience with Excel automation using VBA macros and can help you in short terms with this project, you can check my latest project on this. Can you send me sample data to show you a demo?
HI I am an excel-vba expert and I can help U with your project pm me ...............................................................................................
Hi! I have 8 years experience in programming and know Excel VBA well. I can make this work for you. Everything will be done according to your requirements. I'm ready to discuss details. Denis.
Send me the data files and the steps you undertake to arrive at the output. I can start work right away and deliver a sample even before you accept my bid. That way you can be sure of my capability to do the task.