Access Excel Sales Analysis Reports VBA

  • Status Closed
  • Budget N/A
  • Total Bids 17

Project Description

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)

Get free quotes for a project like this

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online