Excel VBA Financial Reporting
I run a weekly financial report in Excel and it is currently a very long and manual process. I am looking for an Excel VBA expert to automate the process.
I've attached a couple spreadsheets to show you what I'm looking for (with fake sample data).
Each week, I download a .csv file from my payment processor with transaction data for multiple products. See the "import.csv" file.
Then I use that data to create the reports shown in "output.xlsx."
The goal of this project is to minimize the number of steps between the input and the output. Ideally the reports would be created with a single button click.
The contractor should be very strong in Excel and VBA programming. Besides being strong technically, they should understand what I am trying to accomplish and suggest ways to improve the process.
(Note: To show me that you've read this far, add the phrase "Excel Rocks" at the end of your proposal)
I am looking for someone I can use long-term and if they do an outstanding job on this project, there will be another one immediately after.