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)
16 freelancers are bidding on average £168 for this job
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.