I need an excel board easy fully automatic.
Tab 1 is for datas
Tab 2 is for options
Functions must be as following.
Tab 2 :
I will set the year (for example 2018 or any year I want)
I will also set some excluded days in another tab (unlimited amount of excluded days)
First row : Column 1 say "morning", column 2 says "afternoon", then all the months : column 3 is january, column 4 is february, etc. until december, so total 14 columns.
Under "Morning" and "Afternoon", I will put 20 names, one in each row.
Under month columns, file must automatically fill the 20 first days of the month (on in each row too).
These days must exclude the days in tab 2 and also exclude week-ends (saturdays and sundays have not to be shown in month columns).
Also, once first 20 days are filled for every name in the list, the remaining days in the month that are not week-end or excluded are added and shown on the bottom of the actual month column but below the name rows).
Idea is the excel file automaticaly attributes a day in each month for every name for the year I set, excluding week-end and excluded days, and show remaining "free days" in the bottom of each month column.
Format has to be like this (in this format : mon 15, tue 16, wed 17...)
If I change year or add excluded days in tab 2, board must be automatically updated.
Thank you.
Your task is clear to me and I am ready to execute the project for 30 USD for 1 day.
For example, I send a screen of one of my works.
[login to view URL]
$30 USD en 1 día
4,9 (56 comentarios)
5,5
5,5
34 freelancers están ofertando un promedio de $36 USD por este trabajo
Greeting,
I have understood your simple calendar for 2018 on Excel task and can do it with your 100% satisfaction. Please ping me for more discussion.
I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (VBA (macro) projects) without a single problem.
So, if you are interested please message me so i can ask you couple follow up questions, basically just to understand the format of the "options" sheet.
Thanks, Milan
Hi,
Reading your project description about building a simple and dynamic 2018 calendar in Excel makes me feel like you have me in mind when creating the project. I have all it takes to deliver.
You will find in my profile that I have track record of completing similar jobs professionally. If you want I can complete a part of your job as a FREE sample before you award the project. Let my reviews do the talking.
Thanks
Hi there,
I read through the job details and I am absolutely sure that I can do the project very well. I'v good command on Office tools like (Excel, Word, Excel Vba, Macro, Spreadsheet). I will create clean & sample excel calendar as per your requirement. Let's chat for short discussion. Thank You
I’ve gone through your requirement;
I am very much interested to work with you
on this project. I do have expertise in the
specified area. I can start the project right
away and can complete as soon as possible.
Please respond me so that we can discuss it
in-detail. Look forward for your response and
seeking a chance to work with you.
Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros)
I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. I'm really interested. Regards.
Seeking a position as a data entry specialist where I can maximize my accurate keyboard skills in a demanding work , fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately. Excellent written and verbal communication skills and a strong desire to work hard and perform well.
retrieve and present required information in various formats
prepared documents for data entry
verified, updated and corrected source documents
I have done a Diploma in Ms-Office and have experience of working with Ms-Excel and Google spreadsheets in various projects. I can deliver the task within ! day accurately with required formats and fonts.
Happy New Year.I am an experienced finance pro new to freelancer.com. I will be happy to create an automated excel file that will serve all your needs.
Dear Employer, my name is Chris and I am an expert in Excel Modelling. I can deliver your request. I would love to discuss your project with you. Thank you for taking the time to read my application.
Relevant Skills and Experience
Excel Expert
Power BI
MS Office Specialist
Visual Basic
Business Analysis
Business Plan
Business Forecasting
Excel Modelling
Data Processing SEO Data Entry Engineering Excel Photoshop Android Customer Support Marketing Transcription Virtual Assistant PDF Research Writing Article Rewriting HTML Wikipedia Creative Writing Content Writing Social Media Marketing Microsoft Office