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.

Compétences : Traitement de Données, Développement de bases de données, Programmation de bases de données, Excel

en voir plus : 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

Concernant l'employeur :
( 8 commentaires ) Brampton, Canada

Nº du projet : #13463206

Décerné à:


Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% CAD en 5 jours
(507 Commentaires)

23 freelance font une offre moyenne de $380 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(254 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 4 jours
(196 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(135 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(138 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(195 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(53 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(58 Commentaires)

please clarify details and deadlines

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(11 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(46 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(61 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(9 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(47 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(8 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(18 Commentaires)

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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(14 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(10 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(8 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(6 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 30 jours
(6 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 0 jours
(9 Commentaires)