Access Excel Sales Analysis Reports VBA

CLOSED
Bids
17
Avg Bid (GBP)
£162
Project Budget (GBP)
£20 - £250

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)

Additional Project Description:
10/06/2011 at 9:51 PHT
Please note that the data shown in the 'database' sheet is not a table in the database, it is a query working on 3 tables. So I imagine a query will have to be run in Access, then the results pulled into Excel. But you will know best as expert provider :)

10/06/2011 at 9:51 PHT
Please note that the data shown in the 'database' sheet is not a table in the database, it is a query working on 3 tables. So I imagine a query will have to be run in Access, then the results pulled into Excel. But you will know best as expert provider :)

Skills required:
Accounting, Excel, Microsoft Access, SQL
Additional Files: Sales-Anna-Rqts.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire schandraram
£ 175
in 2 days
£ 200
in 2 days
£ 250
in 2 days
Hire DrTech76
£ 75
in 1 days
£ 100
in 1 days
£ 200
in 3 days
£ 90
in 3 days
Hire DeoTech
£ 250
in 4 days
£ 75
in 2 days
Hire mdalamgirh
£ 150
in 7 days