Closed

Update MS Excel Sheet and Chart with MS Access Data

I have a ms access sales order entry database. I Want to have a form that allows a user to select sales by a monthly date range - for example - sales from 01/01/2017 to 01/31/2017. After selecting the data, I want to refresh a MS Excel spreadsheet with the data.

The Spreadsheet chart groups the sales by salesperson, showing a dollar amount and a percentage of total sales (see image attached). I also want to user to be able to save the excel file and send it to others with the data in it.

I can provide a sample database with orders entered, and the form that selects the data by date range and places it into the table that Excel will connect to. I can also provide a sample excel file that uses a similar chart - I want the chart to be on tab 1 and the data to be on tab 2.

I need the excel file created, and the VBA coding in Access so the access data refreshes when a user selects a date range from the access form.

An image of the chart to be generated is uploaded, as well as a pdf and database.

After this small task, I have other spreadsheets that need to be created using the same methods.

Skills: Excel, Microsoft Access, Microsoft Office

See more: update access table from excel spreadsheet, link access table to excel 2010, update excel spreadsheet from access database, excel get external data from access not working, how to use access with excel, import data from access to excel, link excel to access query, how to connect excel to access database using vba, excel 2010 vba export access data excel sheet, data entry sheet design excel, update excel sheet access, transfer data access excel sheet, access data update excel, read update excel sheet access, combining data access excel

About the Employer:
( 33 reviews ) Everett, United States

Project ID: #14422428

56 freelancers are bidding on average $142 for this job

prameswara

Hello Sir Im excel VBA macro and formula Expert and i can do your project Sir :) Relevant Skills and Experience i have many experienced did excel VBA and formula Project Sir :) Proposed Milestones $100 USD - after j More

$100 USD in 3 days
(287 Reviews)
6.8
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$100 USD in 3 days
(168 Reviews)
6.8
Webxpert4u

Hello, I can Update your MS Excel Sheet for sales order entry database. LET'S DISCUSS before starting the task. I would love to work on this task. I can easily do any task in excel for example, creating macro More

$150 USD in 3 days
(118 Reviews)
6.9
paris2785

I've read your brief and can see that you'd like to have a database. Relevant Skills and Experience I have 7 years’ experience designing and developing Access databases. Proposed Milestones $200 USD - I would approac More

$200 USD in 7 days
(139 Reviews)
6.6
dpune

create a VBA to generate excel chart based on selected date range. Relevant Skills and Experience MS Access/VBA/Excel Proposed Milestones $150 USD - Completed VBA

$150 USD in 4 days
(112 Reviews)
6.2
axiomswb

we have expertise in this domain(Access,Excel VBA , DBA,data processing). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience Access,Excel VBA , DBA,data processing Propos More

$70 USD in 2 days
(30 Reviews)
5.4
fuentro

A proposal has not yet been provided

$138 USD in 3 days
(22 Reviews)
5.7
zu02

Dear, Customer I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. In my portfolio Look More

$555 USD in 10 days
(34 Reviews)
5.9
srinichal

I am an expert in delivering custom scripts and softwares willing to discuss further details about the project Relevant Skills and Experience I am an expert in delivering custom scripts and softwares willing to discus More

$155 USD in 3 days
(15 Reviews)
5.3
shafaqat11

Hello Sir, Thank you for posting the project. I read your project description. I understand your requirement for this job. I've more than 3 years experience in related field. Let’s go for interview to justify mys More

$88 USD in 3 days
(69 Reviews)
5.3
$194 USD in 3 days
(41 Reviews)
5.6
workerbee1974

My passion is building Custom Access Databases. I have screen shot samples and more reviews at [url removed, login to view] Relevant Skills and Experience I have taken all classes from beginner to More

$155 USD in 3 days
(18 Reviews)
4.9
JLQ006

Evrything seemed to be straight forward. I can finish this within the day.

$100 USD in 1 day
(16 Reviews)
4.3
crypthne

I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and More

$77 USD in 3 days
(26 Reviews)
4.4
SergeyKyiv

I have seen files you attached and see that I can implement what you need Relevant Skills and Experience I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Propo More

$120 USD in 3 days
(10 Reviews)
3.9
conforti

Give me more details about it

$80 USD in 3 days
(8 Reviews)
3.5
Cupilo

What I would do is create a form in the Access database that will present a report to the user, according to the criteria that he select. Then, using a button, you can generate the Excel file or send it by e-mail. I w More

$200 USD in 10 days
(1 Review)
2.7
sunitagiriprad

Over all 15+ years of IT industry experience in Client /Server, Desktop and Window Application / Web Applications using Microsoft Technologies. Relevant Skills and Experience - VB.Net, ASP.Net, C# - VBA and Macro More

$144 USD in 3 days
(6 Reviews)
2.9
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$150 USD in 3 days
(6 Reviews)
2.4
$180 USD in 30 days
(7 Reviews)
2.7