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:


Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on and have been featured by the freelancer community ( Lisää

$400 CAD 5 päivässä
(507 Arvostelua)

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$300 CAD 3 päivässä
(254 arvostelua)

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)

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 kindly open PM to discuss work and budget..I am based in california Lisää

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

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)

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)

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)

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)

please clarify details and deadlines

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

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)

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)

A proposal has not yet been provided

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

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)

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)

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)

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

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

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)
$288 CAD 10 päivässä
(8 arvostelua)

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)

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)

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)