Access Excel Sales Analysis Reports VBA


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)

Skills: Accounting, Excel, Microsoft Access, SQL

See more: sales analysis report excel, vba sales report, vba sales reports, access sales analysis, sales analysis excel, sales analysis report access, look sales report analysis, vba sales increase decrease, sales analysis report example excel, sales report excel vba, sales analysis vba, vba access excel analysis, sku analysis excel, sales analysis project report, sales analysis reports, vba sales analysis excel, excel vba sales report, access example sales report, sales report access, sales report vba database excel, excel vba sales reports, vba access developer, job in sales, it sales job, how to start developer in excel

About the Employer:
( 22 reviews ) London, United Kingdom

Project ID: #1236359

16 freelancers are bidding on average £168 for this job


Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

£175 GBP in 2 days
(107 Reviews)

Access expert here. Please check my profile. Thanks!

£200 GBP in 2 days
(39 Reviews)

I am a Management Accountant with 20 years experience, and very strong Excel & VBA skills.

£250 GBP in 2 days
(12 Reviews)


£75 GBP in 1 day
(37 Reviews)

hi, I’m very much familiar with SSIS SSAS SSRS and also during last three years I involved many project in ETL, data warehousing, BI reporting and 5 years of application development experience. I would highly app More

£100 GBP in 1 day
(27 Reviews)

Please a better solution on PMB. regards

£200 GBP in 3 days
(4 Reviews)

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

£90 GBP in 3 days
(3 Reviews)

Hi! If you have data in MS Access, and database sheet calculating fast in Ms Access I can create query in MS Aceess. It will be work fast. Resul will be past from Acess in up to couple sec. Regards. P.s. If More

£250 GBP in 4 days
(5 Reviews)

Fully understood what you need. I guarantee perfect output, zero bugs and fast delivery. Full details in pm. Thanks

£75 GBP in 2 days
(3 Reviews)

I think I can do this job.

£150 GBP in 7 days
(0 Reviews)

Hi, very interested in putting together a solution for you. I have over 15 years experience with Access, Excel. I have written numerous systems using both technologies. Looking at your requirements as well as the is More

£150 GBP in 14 days
(0 Reviews)

i have a good experience in ms office macros

£200 GBP in 2 days
(0 Reviews)

Hello, Please see PM. Thanks

£250 GBP in 4 days
(0 Reviews)

Dear Sir/Madam, I am a certified SQL Server developer/administrator have quality experience in query optimization and data extraction and reports.Please give me this task i will solve this within given time duration More

£220 GBP in 3 days
(0 Reviews)

Please Check My PM

£30 GBP in 3 days
(0 Reviews)

Hello i can do it, but need more details, also send me access file from which you want to pull data,

£200 GBP in 1 day
(0 Reviews)

I am expert in Excel and helped design the ECDL syllabus and tests at advanced level. Based in Ireland, I am available during the working day for consultation by Skype, messaging or email.

£145 GBP in 2 days
(0 Reviews)