Completed

Excel based performance report - VBA update / Redesign

PLEASE REVIEW THIS DOCUMENT BEFORE CONTACTING ME.

We have a performance report developed in VBA that was assembled at the beginning of 2017. We need to make some updates to the report and I'd like a design refresh.

The report lists doctors that have ordered a particular service from our company. The report separates the orders by province and highlights doctors that are ordering the test for the first time. (new doctors).

For 2018 we need to:

- Make changes to the abbreviations that represent the Provinces in the Raw data (MA --> MB, NF --> NL, SA --> SK, AL --> AB, YK --> YT)

- For Ontario, separate the province into 2 sales territories (based on Forward Sorting Addresses)

- In addition to the list of doctors that are ordering the service for the first time, we also need a list of doctors that haven't ordered the test in 3 months in a separate tab along with the month that they last ordered.

- Redesign the report output so that its nicer looking

- The heat map should be removed.

I have included a copy of our current report along with an example of how the raw data is submitted, with new province abbreviations.

Happy to discuss further via Skype

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel sales performance report, table based rtf report vba access, populate form vba update excel, data entry, data processing, sql, excel, visual basic, visual basic for apps, microsoft excel, oracle excel vba update, excel vba update workbook closed workbook, excel vba update project, error closing excel vba update, vba update excel worksheet opening, read csv excel table report vba, excel vba update fields, excel based report generation, excel vba update closed sheet, vba excel show sheet report time

About the Employer:
( 2 reviews ) toronto, Canada

Project ID: #15851642

Awarded to:

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an More

$300 CAD in 3 days
(565 Reviews)
8.2

14 freelancers are bidding on average $369 for this job

cgullapalli

HI, I am good at Excel and vba. I have looked at the partially. Happy to discuss further to get the complete requirements. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel, vba. More

$300 CAD in 3 days
(667 Reviews)
7.7
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with the changes you need in the reports. Please check my profile and contact me to discuss further details. Regards.

$300 CAD in 5 days
(238 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia More

$300 CAD in 5 days
(192 Reviews)
6.8
zu02

Better way via ms Access software with Excel automation.. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $750 CAD - default

$750 CAD in 6 days
(30 Reviews)
5.7
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. I have went through your requirements and i am confident that i can help you with it Relevant Skills and Experience Data Ent More

$444 CAD in 5 days
(41 Reviews)
5.2
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

$255 CAD in 5 days
(18 Reviews)
4.5
insidenetsoft

SKYPE Bonjour, We could discuss the changes that you want to implement for starting fresh with this file in 2018 and I could come with some ideas following the other projects I was involved in. PRICE will be e More

$280 CAD in 5 days
(26 Reviews)
4.3
nurnga1218

Hi, I've downloaded your documents and I think I can do what you want. But we can't discuss via skype. We only allowed to discuss with this platform only, don't worry I'll assist you Relevant Skills and Experience I a More

$250 CAD in 4 days
(36 Reviews)
4.4
liangjongai

I can help you. I've an experience of works like yours. Ping me any time. Stay tuned, I'm still working on this proposal.

$555 CAD in 10 days
(5 Reviews)
3.9
vmadhavan15

I am not a random bidder. Could you please provide more details via skype. Please ping me if you are interested with my proposal and thank you

$300 CAD in 5 days
(13 Reviews)
4.1
adrianbrough

I would make the changes requested and tidy up the reports to have a cleaner fresher look and to more clearly separate out the different data areas. I would consult with you for guidance here. Relevant Skills and Expe More

$500 CAD in 10 days
(0 Reviews)
0.0
allenmattson

Hello, I have read and reviewed your project in its entirety and I am very interested in helping you. I am 100% confident that this project is well within my skill set. Could we set up a Skype 1 on 1 this week? Message More

$388 CAD in 30 days
(0 Reviews)
0.0
reedsystems

Hi, how are you today? I read your request, from your description, I understand that you need to make some changes to some abbreviations, split sales territories, redesign reports......... Relevant Skills and Expe More

$250 CAD in 7 days
(1 Review)
0.0