Completed

Excel sheet (+VBA) to create automatically updating priority list for different jobs

We are a small company that deals with the repair/service of camera and associated equipment. We have been struggling with prioritising work as some jobs require more work/time. At the same time, there may be jobs that are urgent. We would like to also limit the number of jobs the technician sees in one day. It may be possible that there is a software available that can do this, but I haven't come across any specific to our needs.

An excel sheet that automatically updates each time it is opened to create this priority list would help this business to complete jobs more efficiently. I currently have an idea of how the jobs need to be prioritised and how long certain jobs may take.

Ideally it would be someone local as it would be helpful to meet in person to discuss our needs; however, if it is possible to complete the job without meeting, that's fine also.

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

See more: excel sheet format india city wise state list, import access table excel sheet vba, importing excel sheep excel sheet vba, work from home excel projects, get paid to make excel spreadsheets, home based excel jobs, freelance excel work uk, online excel job home based, freelance excel jobs from home, excel spreadsheet jobs from home, excel jobs from home part time, data entry, data processing, excel, visual basic, fed web page details excel sheet vba, export data multiple excel sheet vba, data webpage excel sheet vba, copy html anchor text excel sheet vba, convert excel sheet vba code

About the Employer:
( 1 review ) Ashfield, Australia

Project ID: #16101459

Awarded to:

katiewells3

Australian based (Qld) Business Analyst with 15+ years experience in developing complex business solutions using Excel+VBA- deliver clean, user-friendly, stable solutions Relevant Skills and Experience Completed numer More

$111 AUD in 3 days
(14 Reviews)
4.2

22 freelancers are bidding on average $147 for this job

mrbrave

Using VBA and GUI, I will develop a tool which will help you setup rules to automate the process. Tool will also show the status of each job in kanban style with different color coding. Relevant Skills and Experience More

$188 AUD in 5 days
(219 Reviews)
6.6
caabdul

Hi there, I can prepare excel VBA tool, that will work as project management tool as well as priority analyzer. Rest, as you want, I can do. Thanks Relevant Skills and Experience Excel vba Proposed Milestones $250 AU More

$250 AUD in 2 days
(55 Reviews)
5.8
SShtv

One of the areas of my work is the automation of business processes. For example, I send screenshots of some of my work done. Relevant Skills and Experience [login to view URL] More

$150 AUD in 3 days
(44 Reviews)
5.2
usmanhassan123

mphill in computer science and expert in such tasks.

$150 AUD in 1 day
(21 Reviews)
5.0
polarjin2017

Hello? How are you? I have good skills in excel vba. So i can help you then. Thanks. Relevant Skills and Experience ` Proposed Milestones $155 AUD - `

$155 AUD in 3 days
(22 Reviews)
5.1
citijayamala

1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, Relevant Skills and Experience and Business intellig More

$150 AUD in 3 days
(45 Reviews)
5.2
dayakmlt

Requirement can be discussed in chat box. There is too and fro transaction will be there Relevant Skills and Experience .. Proposed Milestones $88 AUD - ..

$88 AUD in 3 days
(14 Reviews)
3.6
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. Relevant Skills and Experience I have experience in writing macros VBA for Excel Proposed Milestones $77 AUD - to do work

$77 AUD in 5 days
(7 Reviews)
3.1
sysdesigner13

This is trivial as to touch my toe. I have rich experience on VBA for Excel and data processing. Relevant Skills and Experience VBA, Excel, Data Processing Proposed Milestones $100 AUD - discuss

$100 AUD in 2 days
(2 Reviews)
2.5
jacobscotsutton

I will complete the project in three days or less, following all instructions carefully and explaining the logic behind every component to you so you understand the sheet fully. Relevant Skills and Experience I have p More

$250 AUD in 3 days
(1 Review)
0.8
$155 AUD in 3 days
(0 Reviews)
0.0
Newtechprogramer

Hi,   I have gone through your project details and I assure I can do it  as  i got all the skills  required for this project. I have already completed a lot of similar  projects in the past so it is my pleasure to work More

$30 AUD in 3 days
(0 Reviews)
0.0
$155 AUD in 7 days
(0 Reviews)
0.0
ludwig333

hello i have read your description very carefully. i understand what you want and what to do. i can finish your job in time perfectly. Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual More

$155 AUD in 3 days
(0 Reviews)
0.0
$111 AUD in 4 days
(0 Reviews)
0.0
rochelleandrada

I can copy any data needed. Need only to be told instructions once. Im not afraid to ask about something im unsure and can get the job done precisely yet in a timely matter, prefessionally. No errors. Relevant Skills More

$138 AUD in 3 days
(0 Reviews)
0.0
Sopan143

I have more than 2-year experience in Excel VBA, I can complete your requirements within the timeline. Relevant Skills and Experience Excel VBA, Excel Coding Proposed Milestones $161 AUD - Will Delivered in 3 days

$161 AUD in 3 days
(0 Reviews)
0.0
shumuga

A proposal has not yet been provided

$222 AUD in 10 days
(0 Reviews)
0.0
$133 AUD in 3 days
(0 Reviews)
0.0
jemmauleon

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
0.0