Find Jobs
Hire Freelancers

Attendance Dashboard - Create VBA to count the color of conditional formatted cells and give instructions based on the count

$10-30 USD

Geschlossen
Veröffentlicht vor etwa 7 Jahren

$10-30 USD

Bezahlt bei Lieferung
I have an attendance dahsboard-tracker that helps me track all the incidents at my site per employee and per year, however I want the tracker to count all the incidents that happened in a specific month and to give me an action to do based on that count. The problem that I have is that all the incidents of the dashboard are showing based on conditional formatting so Excel cannot count the colors of the cells because they are not manually filled. I need someone that could write the VBA code to count the colors of the cells of each row (month).
Projekt-ID: 13246382

Über das Projekt

30 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
30 Freelancer bieten im Durchschnitt $48 USD für diesen Auftrag
Avatar des Nutzers
How long will it take you to finish the job? I can make the code in max 2 days. Proposal: Hello Sir, We can build an automated scrapper which can be configured to the specific site you need, and on click of a button, it will fetch you the prices whenever you click on it within seconds. About me - My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$100 USD in 1 Tag
5,0 (513 Bewertungen)
8,0
8,0
Avatar des Nutzers
How long will it take you to finish the job? I have the 5 years of experience and have delivered 142 projects with 100% client satisfaction. Proposal: 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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$150 USD in 1 Tag
4,9 (198 Bewertungen)
7,1
7,1
Avatar des Nutzers
How long will it take you to finish the job? 24 hours from time of awarding the project. Proposal: Past experience in handling more than 300 Excel VBA projects. Need a clarification on the rule: 3 days of absence amounts to termination. What is the minimum limit of absence in days for termination ?
$60 USD in 1 Tag
5,0 (163 Bewertungen)
7,2
7,2
Avatar des Nutzers
How long will it take you to finish the job? 3 days Proposal: ZERO ERROR GUARANTEED!! Please read my 170+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$150 USD in 3 Tagen
5,0 (155 Bewertungen)
6,9
6,9
Avatar des Nutzers
How long will it take you to finish the job? Hello, This job can be done within a couple of hours. I have done several similar color coding cells count using VBA before. Please share the sheet and discuss. Thank you, Usman Proposal: I have done several similar projects before so I exactly know how to handle it.
$110 USD in 1 Tag
5,0 (67 Bewertungen)
6,7
6,7
Avatar des Nutzers
How long will it take you to finish the job? I can do exactly what you need within 24 hours or less. Proposal: I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$50 USD in 1 Tag
4,8 (159 Bewertungen)
6,9
6,9
Avatar des Nutzers
How long will it take you to finish the job? The project will take 15-20 mins to complete the job Proposal: Hi: I understand that you want just the count of orange cells and then if count is greater then three then it should display "Termination". Please confirm. Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects.
$25 USD in 1 Tag
4,9 (148 Bewertungen)
6,8
6,8
Avatar des Nutzers
How long will it take you to finish the job? 2 days Proposal: 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. They speak for themselves. Best regards
$50 USD in 2 Tagen
5,0 (172 Bewertungen)
6,7
6,7
Avatar des Nutzers
How long will it take you to finish the job? One day. Proposal: Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$25 USD in 1 Tag
4,9 (113 Bewertungen)
6,4
6,4
Avatar des Nutzers
How long will it take you to finish the job? Max 4 hours from the time of project acceptance. Proposal: Greetings! I understand that you need cells AY9 to AY20 in "Dashboard" tab to be populated based on Absences data in Col H to AW. I can write a macro that would populate the needed information whenever you select an employee. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last few MONTHS , I have spent at least 225 HOURS on automation in Excel every month. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$25 USD in 0 Tag
5,0 (119 Bewertungen)
6,2
6,2
Avatar des Nutzers
How long will it take you to finish the job? I reviewed the requirement and can finish the job in less than a day. I will need your spreadsheet and a couple of examples to be able to get going on it. Proposal: Hello there, I am an expert in Excel based systems and have designed some very large and complex spreadsheets. I have successfully completed more than 500 projects here on freelancer and can assure you of excellent quality work. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you and thank you for considering my bid Best Regards, Rishi (Automyze Consulting)
$83 USD in 1 Tag
4,8 (90 Bewertungen)
6,3
6,3
Avatar des Nutzers
How long will it take you to finish the job? It takes about 1-2 hours Proposal: Dear the client, I hope my message sifts through spams and finds you well. Unlike other bidders, I took a careful look at your file. As I see when you change the employee also changes the year. you want to count the orange cells. It's a pretty easy task to do. My name is Hai. I'm an expert in VBA and excel templates. I helped many clients create their VBA and advanced excel templates. Contact me
$30 USD in 1 Tag
5,0 (31 Bewertungen)
5,3
5,3
Avatar des Nutzers
How long will it take you to finish the job? Should be able to finish in 2 days. Proposal: - Can get the count of incidents per the color coding. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects.
$30 USD in 2 Tagen
5,0 (37 Bewertungen)
5,2
5,2
Avatar des Nutzers
How long will it take you to finish the job? It will take 30 minutes to finish the job but the maximum return time that I promise is 3h as I might be busy at the exact moment you contact me. Proposal: Hello, I am working with Excel for a long time and I can create complex formulas and macros. It's very simple to read the color and make the count. Please open a chat with me if you are interested. Kind regards, Sorin
$25 USD in 1 Tag
5,0 (33 Bewertungen)
4,8
4,8
Avatar des Nutzers
How long will it take you to finish the job? Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I can work on conditional format and count the color code and give your consolidated report. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets. Thanks, Virendra Proposal: I can do this job nicely and will take 3 hours to complete this task
$45 USD in 1 Tag
4,8 (43 Bewertungen)
4,7
4,7
Avatar des Nutzers
How long will it take you to finish the job? I could finish your job today Australian time (currently it is 3:30pm) - subject to the outline discussed below. Proposal: Hi, I am a native English speaking finance professional with over 15 years experience using Excel. I can help with your project. I would propose to use a formula rather than VBA to complete your project. I would use the "Tracker" sheet to calculate the formula - but I would need you to enter the absences into the "tracker" for each month if they are crossing over a month. For example, Evaristo Ochoa was absent from 31/1/17 to 4/2/17 - I would need you to enter this as separate months with 2 absence periods - or be happy to include all of the "absence days" in February rather than separated into 2 months. Please let me know if you have any questions. Thanks & regards Melanie
$35 USD in 1 Tag
5,0 (11 Bewertungen)
4,2
4,2
Avatar des Nutzers
How long will it take you to finish the job? 1 hour - It's quite simple task if you count days that meets conditional formating criteria enstead of colors. Proposal: Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and analyze data. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? I have one question about this project. Why you want to count colored cells instead of count day tha meets critera of conditional formating. With this way of thinking it's quite simple task. Have nice day, Rafael Ps. This could be one of my first projects here, so give me the chance to proof that i'm really good business partner.
$10 USD in 0 Tag
4,9 (10 Bewertungen)
4,2
4,2
Avatar des Nutzers
How long will it take you to finish the job? I can complete it within 3 hours. Proposal: I'm an Excel VBA expert and can get it done with excellent quality as desired.
$20 USD in 0 Tag
4,9 (9 Bewertungen)
3,7
3,7
Avatar des Nutzers
Hi ! Can i take a look at your excel file please. I believe i can finish it in 2 hours more or less. Are you still open for discussion ?
$30 USD in 2 Tagen
4,9 (8 Bewertungen)
2,5
2,5
Avatar des Nutzers
How long will it take you to finish the job? I can complete within a day after assignment. Proposal: I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
$16 USD in 1 Tag
5,0 (2 Bewertungen)
1,7
1,7

Über den Kunden

Flagge von UNITED STATES
United States
0,0
0
Zahlungsmethode verifiziert
Mitglied seit Feb. 28, 2017

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.