Find Jobs
Hire Freelancers

Dynamic personel calendar (Annual)

$30-250 USD

Mbyllur
Postuar about 5 years ago

$30-250 USD

Paguhet në dorëzim
We have worked on this sheet trying to get it to work and we are so close. Having extremely limited excel knowledge, we tried to get this thing to work using conditional formatting (entering "v" for vacation and the cell changes color, etc), and dynamic lists (employee names, titles, location) located in the "data" tab, and some vba codes that were obtained from on line. The problem that we are having is that when we add a row on the master list in the "data" sheet, we need it to move down a row across the entire "month" sheet. I believe the problem is having multiple tables on "month" sheet which is prohibiting the line fill all the way across the sheet. Unfortunately, now that they are there, we don't know how to remove the tables. Please help. We are at a loss.
ID e Projektit: 18914038

Rreth projektit

13 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
13 freelancers are bidding on average $128 USD for this job
Avatari i Përdoruesit
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD në 3 ditë
4,9 (377 përshtypje)
8,1
8,1
Avatari i Përdoruesit
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel fixed in terms of VBA code. I've worked with Excel-based calendars in the past. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $180 and can deliver within three days (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$180 USD në 3 ditë
4,9 (264 përshtypje)
7,6
7,6
Avatari i Përdoruesit
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
$200 USD në 3 ditë
4,9 (272 përshtypje)
7,1
7,1
Avatari i Përdoruesit
I can definitely help you with that. I am an advance level Excel user holding years of experience in utilizing advance level tools and functions of various data analytics tools including Excel. I will be discuss further and explain how I am highly suitable for this project.
$50 USD në 1 ditë
4,7 (72 përshtypje)
5,8
5,8
Avatari i Përdoruesit
Hello, I can help you with your please, send me a message with some details of its possible the file so I can check it and start working on it inmediately.
$50 USD në 4 ditë
5,0 (33 përshtypje)
4,1
4,1
Avatari i Përdoruesit
Hi there, Good day! I can help you get the work well done within 1 day. Feel free to contact me if any. Best Regards,
$80 USD në 1 ditë
4,9 (11 përshtypje)
3,7
3,7
Avatari i Përdoruesit
Hi) First of all - I advice You to go to Google Sheets Second - Im developer and Im sure this work must do developer 3d - conditional formatting isnt very good idea. It takes resources for always calculate these conditions etc. So I recommend instead use some scripts with EVENTS - OnChange. But You dont need to care about that - its my problem But what I want from You is comments how You want it to work. Dont care about methods - just say me what You want as result. Ill care about development BUT - all this ill do only for Google Sheets. I will not work with Excel etc. Lets discuss)) Thanks.
$120 USD në 7 ditë
5,0 (2 përshtypje)
3,4
3,4
Avatari i Përdoruesit
Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Please let me know your requirements. Regards
$30 USD në 1 ditë
5,0 (7 përshtypje)
1,9
1,9
Avatari i Përdoruesit
Hi, Greetings!!! I am an expert in data entry solutions and also in EXCEL automation using VBA macros. The requirement which you mentioned seems interesting for me. Provided with an opportunity, I would like to start working right now and complete within 2 days. I would like to get little more details in a chat. Please feel free to chat in case you are interested. Thanks and awaiting your reply
$77 USD në 2 ditë
5,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
Dear Client, I hope you are doing great! I understand you need an Excel expert who can clear the hurdle and make this important project work. My name is Ajay, I am good with excel, VBA, Data Management, Process Automation, Reporting and many other things in the same field. I have a looked at the file you shared, I am being honest, it looks good but needs simplification or this file can be replaced with a tool which is easy to use and help you analyze the data as well. Like Trend of Absenteeism/Sick etc. Let's call this tool Attendance Management System (AMS). My Proposal Input: Simple and explanatory Control Forms, Checks, Drop-downs. Tech: Excel & VBA Output: Reports or analysis, which can help you judge your employees rightly using Data Analytics. Businesses are using data for strategic decision, like who are most loyal or sincere or careless employees, Attendance data can help in the same. I think this is the time for you to spend the money wisely else in a few months you may need another advancement and spend more. I can fix the file but recommending AMS as a better system. I can develop such tool in just a little higher cost. Let me know for any help. Please find attached samples in my portfolio to judge my skills in Excel & VBA. With me you get 1. On time and accurate delivery 2. Pleasant experience, Timely update and SOP 3. As I am PMP certified, so best Project Management 4. Analytical and Solution Oriented Approach Hope to hear back soon Thank you Ajay
$250 USD në 15 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Fort Lauderdale, United States
0,0
0
Anëtar që nga mar 10, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.