Find Jobs
Hire Freelancers

Update MS Excel Sheet and Chart with MS Access Data

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 14422428

About the project

54 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
54 freelancers are bidding on average $142 USD for this job
User Avatar
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 job completed
$100 USD in 3 days
4.9 (299 reviews)
6.9
6.9
User Avatar
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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD in 3 days
4.9 (191 reviews)
7.1
7.1
User Avatar
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 approach your project by creating a draft Access database and send it to you for review. When can we chat? I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3).
$200 USD in 7 days
4.8 (150 reviews)
6.7
6.7
User Avatar
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
4.9 (114 reviews)
6.2
6.2
User Avatar
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 myself. I will be highly glad to you. Thanks so much! Shafaqat Ali
$88 USD in 3 days
4.8 (76 reviews)
5.4
5.4
User Avatar
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 Proposed Milestones $70 USD - whole
$70 USD in 2 days
5.0 (32 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$138 USD in 3 days
4.7 (25 reviews)
5.8
5.8
User Avatar
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 discuss further details about the project Proposed Milestones $155 USD - milestone
$155 USD in 3 days
5.0 (15 reviews)
5.3
5.3
User Avatar
Evrything seemed to be straight forward. I can finish this within the day.
$100 USD in 1 day
5.0 (23 reviews)
4.5
4.5
User Avatar
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 maintenance with Linux/Unix and Windows Networking.
$77 USD in 3 days
4.9 (27 reviews)
4.4
4.4
User Avatar
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. Proposed Milestones $120 USD - project as described Additional Services Offered $1 USD - Client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Would you like MS Access to run Excel file, or "Update" button needs to be in Excel?
$120 USD in 3 days
4.8 (11 reviews)
4.1
4.1
User Avatar
Give me more details about it
$80 USD in 3 days
4.9 (8 reviews)
3.5
3.5
User Avatar
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, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$150 USD in 3 days
5.0 (9 reviews)
2.9
2.9
User Avatar
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 would like to send you an example image of what the form would look like. I am very good at designing database solutions and have worked extensively with user interface. I like practical solutions; simple but covering all of the client's requirements. I work fast because I have a lot of experience in the field. I have more than 500 hours in training, certifying and lecturing personnel in all phases of Access. I have sent you a very affordable proposal. If you hire me you will not regret it. Please contact me. Thank you. Camilo
$200 USD in 10 days
5.0 (1 review)
3.0
3.0
User Avatar
You should explain me: what field map between cells on worksheet and columns/fields of generated records from query. Then I could write a VBA code which will utilize the MS Excel Object Model Relevant Skills and Experience VBA and MS Excel Object Model Proposed Milestones $180 USD - Final Cost Please, provide me map of fields between worksheet and query
$180 USD in 3 days
4.8 (1 review)
2.2
2.2
User Avatar
This seems to be a pretty straight forward request. you would need to write a macro in excel that runs a query in access that builds the data. I did a similar project for a fairly large fortune 300 company (13b in sales annually) so they could create a daily report monitoring how much space and inventory was in their warehouses. please let me know if you would like to collaborate on this. Thank you Ryan from Long Island
$40 USD in 2 days
5.0 (1 review)
1.2
1.2
User Avatar
I am a Microsoft Certified Professional,Microsoft Certified Trainer,I have extensive experience,I can quickly do the macro,all my works completed and 5 stars That gives you confidence of success Relevant Skills and Experience VBA, Excel, Access, ... Proposed Milestones $200 USD - Project Finished
$200 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Hi, your project caught our attention and hope we can work together to make your idea into a reality Relevant Skills and Experience We have over 9 years of experiences and have written VBA modules which uses multiple platforms. thus be assured that we will execute your request effectively. Proposed Milestones $75 USD - extracting data from Ms Access and updated in Excel $75 USD - generate another Workbook, PDF and Charts with user criteria please do not hesitate to talk to us if u have any query, looking forward to work with you.
$150 USD in 5 days
5.0 (1 review)
1.1
1.1
User Avatar
I am skilled in ms access and excell skills. I will work hand in hand with you to provide the best results I have read the instructions and confident that I will produce the desired results Relevant Skills and Experience Excell/Acess/Data analysis Proposed Milestones $44 USD - Start $44 USD - End Kindly select me for this task
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello my name is Rani. I'm good with excel and other computer skill. Previously I work as technical consultant in smart card company. Currently I have no job and have extra free time, I'm sure capable to meet the dead line perfectly
$55 USD in 3 days
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
Everett, United States
5.0
33
Payment method verified
Member since Jan 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.