Closed

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)

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 :)

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: 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

15 freelancers are bidding on average £174 for this job

rhomeu

Access expert here. Please check my profile. Thanks!

£200 GBP in 2 days
(66 Reviews)
7.0
schandraram

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

£175 GBP in 2 days
(76 Reviews)
6.2
marasinghe82

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 appre More

£100 GBP in 1 day
(66 Reviews)
5.7
gshiels

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

£250 GBP in 2 days
(12 Reviews)
5.2
DeoTech

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
(13 Reviews)
4.7
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

£90 GBP in 3 days
(3 Reviews)
4.1
ExactSystems

Please a better solution on PMB. regards

£200 GBP in 3 days
(4 Reviews)
4.5
farazlogics

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)
0.0
ghazanfarkavish

Dear Sir/Madam, I am a certified SQL Server developer/administrator have quality experience in query optimization and data extraction and [url removed, login to view] give me this task i will solve this within given time duration More

£220 GBP in 3 days
(0 Reviews)
0.0
microtech121

Please Check My PM

£30 GBP in 3 days
(0 Reviews)
0.0
SoumayaHamdaoui

Hello, Please see PM. Thanks

£250 GBP in 4 days
(0 Reviews)
0.0
RiochM

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)
0.0
mdalamgirh

I think I can do this job.

£150 GBP in 7 days
(0 Reviews)
0.0
Tim2002

i have a good experience in ms office macros

£200 GBP in 2 days
(0 Reviews)
0.0
stephg1

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)
0.0