Excel sheet work

$30-250 AUD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 6 χρόνια πριν

$30-250 AUD

Πληρωμή κατά την παράδοση

I need to trigger a warning on when services are needed on a simple sheet . I have highlighted the areas that are used . We put totals into column G each week to update and then in column L is where the service KM's are triggered from . It would be an advantage to get a warning if the target has been reached so I can make sure the vehicle gets it's service.

Ταυτότητα εργασίας: 15407655

Σχετικά με την εργασία

23 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@MimiFL

Executing a warning (triggering it) when value in column G (which is update each week) is higher then value in column L (basically finding out that goal has been reached). Relevant Skills and Experience Excel Formulas, Excel VBA, Algorithm, Formulas, Calculation. I suggest that we complete this with single formula or formula + different formatting. Proposed Milestones $40 AUD - Complete work If you are interested in working with me, let me know what kind of message would you like to have when trigger is executed.

$40 AUD σε 0 ημέρα

5,0

(325 αξιολογήσεις)

6,6

23 freelancers δίνουν μια μέση προσφορά $67 AUD για αυτή τη δουλειά

@SBITServices

Hello , I have read your project description and understood your requirement. I have 5 years experience and can complete task with 100% requirements within time. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Visual Basic,Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $30 AUD - Project

$30 AUD σε 2 ημέρες

4,9

(264 αξιολογήσεις)

7,1

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 AUD σε 1 ημέρα

4,9

(215 αξιολογήσεις)

6,8

@nurnga1218

What Warning do you want? would that be a sound or just a color or something? I've downloaded your xls file and I think I understand what you need. Relevant Skills and Experience I am an excel expert and I usually make a kind of an alert with a color. But, If you need it I can also make a sound. Proposed Milestones $40 AUD - Excel allert Stay tuned, I'm still working on this proposal.

$40 AUD σε 1 ημέρα

5,0

(34 αξιολογήσεις)

4,4

@gr8tech

I will provide cell validation in your spreadsheet to check that the Current Odometer has not reached or exceeded The next service mileage. A popup will be displayed when service is due Relevant Skills and Experience I have experience working with Excel Formulas and Validation Proposed Milestones $35 AUD - task completed

$35 AUD σε 0 ημέρα

4,9

(30 αξιολογήσεις)

4,5

@aubrey03

I am an Excel VBA expert. I am confident that I could create a macro that will display a pop up message when certain criterias are met. Feel free to contact me for details.

$30 AUD σε 1 ημέρα

4,8

(15 αξιολογήσεις)

4,4

@saadrashad

We use to set cell color on due date reaching. I can try implementing that scenario on you requirement. i also need to know if u manually type things or drop downs? Relevant Skills and Experience 16 years of experience in relevant field 245 reviews on freelancer.com all with 100% +ive reviews Proposed Milestones $66 AUD - milestone Do you manually type things or select from list? do u want a popup or a color change will also work?

$66 AUD σε 0 ημέρα

5,0

(14 αξιολογήσεις)

3,8

@ScareCrow01

I am good at excel Relevant Skills and Experience excel Proposed Milestones $56 AUD - Full Lets talk in chat so that we can discuss further

$56 AUD σε 1 ημέρα

5,0

(14 αξιολογήσεις)

3,8

@vmadhavan15

it is very simple to add a conditional formula in the column L but could you please provide more details Relevant Skills and Experience Excel Proposed Milestones $35 AUD - final pyament

$35 AUD σε 1 ημέρα

4,7

(6 αξιολογήσεις)

3,3

@shafeekmohamed

I can do the project perfectly, If you want perfect project please contact me..

$30 AUD σε 1 ημέρα

5,0

(4 αξιολογήσεις)

1,3

@paulceralde

Trigger could easily be programmed on excel. I could help you with that. But I need further details on the sheet's functionality. Thanks! Relevant Skills and Experience Undergraduate research made me adept with working on spreadsheets.

$133 AUD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@vijayratiya

A proposal has not yet been provided

$33 AUD σε 5 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@MiraFaith

I am very good in excel which also i did in my past work experience. Relevant Skills and Experience Data entry of patient's different diseases with codes and using merging cells. In statistics, need to merged cells and sum-up the total patients per specialty and by age group.

$155 AUD σε 4 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@sabiaf

A proposal has not yet been provided

$133 AUD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@rajdeep77

Hello, I will provide the auto notification alert through excel VBA. The work will be done in 2 days. Have more than 5 years experience in Excel application build. Relevant Skills and Experience Macro, Excel with more than 5 years experience in both. Proposed Milestones $40 AUD - Auto Alert

$40 AUD σε 2 ημέρες

0,0

(0 αξιολογήσεις)

1,3

@An0naman

The whole row yellow when the KMs in column G equal the number in column L and then red if they go over buy an additional no. of Kms. Message appear seeking confirmation that service has been arranged Relevant Skills and Experience designed and built tools / registers and applications using Excel Proposed Milestones $25 AUD - Build conditional formatting to trigger as requested $30 AUD - Confirm that spreadsheet is working as requested Stay tuned, I'm still working on this proposal.

$55 AUD σε 1 ημέρα