Käynnissä

Automated Excel Sales Report

Hello - I need to automate a weekly sales report. Attached is the weekly raw data of all the sales between Jan 1 and Mar 13, this updates weekly. I have also updated a copy of the report we use today.

The current version seems to crash all the time and is a larger file than I would have expected. I would also like to link the data to google map so we can show where the sales are coming from.

The most important tabs in the attached spreadsheet are:

- Provincial

- Doctor Level (sales by doctor)

- New Doctors (a list of doctors that have used the product for the first time that month. )

The data will update every week and I need a way for the report to easily update when new data is added.

Taidot: tietojenkäsittely, Tietokantakehitys, Tietokantaohjelmointi, Excel

Näytä lisää: sales analysis report example excel, report presentation excel spreadsheet, create car sales excel spreadsheet, populate sales excel spreadsheet, sales report retail excel, car sales excel spreadsheet, data needed track sales excel spreadsheet, sales report graph excel, sales excel sheet report, report card excel spreadsheet, sales report samples excel, sales excel spreadsheet iphone app, sales excel spreadsheet, sales report macro excel, sales report sample excel, macros work excel internet, macro dont work excel 2000, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file

Tietoa työnantajasta:
( 8 arvostelua ) Brampton, Canada

Projektin tunnus: #13463206

Myönnetty käyttäjälle:

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view] Lisää

400 $ CAD 5 päivässä
(507 arvostelua)
8.0

23 freelanceria on tarjonnut keskimäärin 380 $ tähän työhön

300 $ CAD 3 päivässä
(254 arvostelua)
7.6
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 Lisää

400 $ CAD 4 päivässä
(196 arvostelua)
7.2
ponnarasiBabu

I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california Lisää

555 $ CAD 10 päivässä
(135 arvostelua)
6.6
sandroshubladze

Hello I am Excel Expert and VBA Programmer I have been working as a financial audit so I have proper experience for that job and usually thats what I do on freelancer, creating accounting support excel set ups I che Lisää

411 $ CAD 5 päivässä
(138 arvostelua)
6.5
imransgd101

Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satis Lisää

250 $ CAD 2 päivässä
(195 arvostelua)
6.5
ShaunKleinOnline

Hi there, Your project immediately caught my eye and I feel I would be a great fit. I have over 15 years of corporate experience working in Excel and google sheets creating advanced automated dashboards, reports and Lisää

550 $ CAD 5 päivässä
(53 arvostelua)
6.0
MohsanEijaz

Hello there It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in VB, VBA, C++, C#, OPPs, HTML5, CSS3, JS, AJAX, JQYERY, React.j Lisää

333 $ CAD 3 päivässä
(58 arvostelua)
5.7
AlexandrUKR

please clarify details and deadlines

444 $ CAD 5 päivässä
(11 arvostelua)
4.9
younus15

Hello. I have extensive experience in Excel dashboard analyze and reporting in excel, I can do your project in less than a Day according to your description with full delivery and without error. I would also complet Lisää

250 $ CAD 1 päivässä
(46 arvostelua)
4.9
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I can automatize your excel file to input data and get the reports instantly. Please contact me by chat and then we could di Lisää

250 $ CAD 5 päivässä
(61 arvostelua)
4.8
kastriotthaqig

A proposal has not yet been provided

370 $ CAD 2 päivässä
(9 arvostelua)
4.4
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lisää

555 $ CAD 10 päivässä
(47 arvostelua)
4.5
shahiddar

Hello Sir, I am shahid from kashmir. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I'm interested in your project. Please send me a message so that we c Lisää

250 $ CAD 5 päivässä
(8 arvostelua)
4.6
Goalaholic

I can solve the load of your file by writing efficient queries or designing a VBA form where necessary that will ultimately enhance the performance for your work and make your life easy.. I have 5 years of experience w Lisää

288 $ CAD 3 päivässä
(18 arvostelua)
3.8
ksinghrajeev

Hello There, Below are few examples of my work. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] Lisää

400 $ CAD 7 päivässä
(14 arvostelua)
4.1
scorpionobaid01

Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Lisää

250 $ CAD 2 päivässä
(10 arvostelua)
3.5
288 $ CAD 10 päivässä
(8 arvostelua)
3.4
zolibara

Hello, I looked up the Harmony Sales file. It looks like the macro that process the initial file is not very good - probably it doesn't use arrays, and it puts all the results in the Doc PT sheet, which has 30k lines Lisää

250 $ CAD 10 päivässä
(6 arvostelua)
3.2
cracken

Hi Jasonwcrowe, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your Lisää

749 $ CAD 30 päivässä
(6 arvostelua)
2.4
rumesh402

Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I ca Lisää

250 $ CAD 0 päivässä
(9 arvostelua)
2.6