Update MS Excel Sheet and Chart with MS Access Data

$30-250 USD

Chiuso

Pubblicato

quasi 7 anni fa

$30-250 USD

Pagato al completamento

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.

Excel

Microsoft Access

Microsoft Office

Rif. progetto: 14422428

Info sul progetto

54 proposte

Progetto a distanza

Attivo 7 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

54 freelance hanno fatto un'offerta media di $142 USD

@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 job completed

$100 USD in 3 giorni

4,9

(299 valutazioni)

6,9

@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 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 giorni

4,9

(191 valutazioni)

7,1

@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 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 giorni

4,8

(150 valutazioni)

6,7

@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 giorni

4,9

(114 valutazioni)

6,2

@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 myself. I will be highly glad to you. Thanks so much! Shafaqat Ali

$88 USD in 3 giorni

4,8

(76 valutazioni)

5,4

@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 Proposed Milestones $70 USD - whole

$70 USD in 2 giorni

5,0

(32 valutazioni)

5,4

@fuentro

A proposal has not yet been provided

$138 USD in 3 giorni

4,7

(25 valutazioni)

5,8

@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 discuss further details about the project Proposed Milestones $155 USD - milestone

$155 USD in 3 giorni

5,0

(15 valutazioni)

5,3

@JLQ006

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

$100 USD in 1 giorno

5,0

(23 valutazioni)

4,5

@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 maintenance with Linux/Unix and Windows Networking.

$77 USD in 3 giorni

4,9

(27 valutazioni)

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. 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 giorni

4,8

(11 valutazioni)

4,1

@conforti

Give me more details about it

$80 USD in 3 giorni

4,9

(8 valutazioni)

3,5

@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, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$150 USD in 3 giorni

5,0

(9 valutazioni)

2,9

@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 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 giorni

5,0

(1 valutazione)

3,0

@khanicha

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 giorni

4,8

(1 valutazione)

2,2

@rmknakal1027

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 giorni

5,0

(1 valutazione)

1,2

@AllProgs

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 giorno

5,0

(1 valutazione)

1,0

@jdsimplification

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 giorni

5,0

(1 valutazione)

1,1

@ASEKA

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 giorni

0,0

(0 valutazioni)

0,0

@rpurbasari

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 giorni