Access Excel Sales Analysis Reports VBA
This project received 17 bids from talented freelancers with an average bid price of £162 GBP.Get free quotes for a project like this
This project is to create a macro that will pull data from an access database for each months sales of 300 skus and compare the data each fortnight.
Please see attachment
Sheet 1 is how I want the resulting report to look.
It shows the sales of each sku per fortnight, and the percentage increase or decrease in sales compared to the previous fortnight.
I want the percentages to be highlighted depending on their value. I want to be able to set the ranges that the highlights apply to as per my example, then choose the start date, then click run. If the last time period is less than a fortnight, just show the sales for that number of days.
There is example data in the 'Database' sheet within this file. I would like to see the report running with this data before we move to pulling the data from a query in the Access database.
One developer has already tried to do this project but it took about 5 minutes until the report was shown in the excel file.
Please only apply for this job if you can get the data shown in less than 15 seconds of processing time on a modern day PC (Core i7 processor)
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online