Excel Customer Appointment Calender

In Progress Posted Sep 9, 2015 Paid on delivery
In Progress Paid on delivery

I would like to have a Excel spreadsheet that functions as a Calendar where I can input customer appointments. I have an Idea I would like but just do not have the necessary know how to build it. Please seen my mock up of the sheet I would like to create. The Daily, Weekly and Monthly tabs change the schedule view on the right schedule field box. As the picture is set its on daily. under tabs I would like a working calendar that changes with the proper date of the computer. under the calendar I would like a Text form field where when you insert an appointment this form will tell you all the details needed to complete the appointment. Under the Text field I would like another Text bar which will tell you if this Appointment is for a Tire change or Oil Change. Under that I would like to change what is on the screen shot. As of right now it has one tab with a Mark customer as In- Service. I would like to change it to three tabs of equal size in the same location that reads "Here" "In-Service" "Done". I would like to when clicking on a customers appointment and they arrive I click the here tab and it changes the appointment color to red, In-Service is Yellow and Done is Green. Under those three tabs I Would like to add a Print Tab that will print out the daily appointments. On the right side of the screen I would like another Calendar that on the Day View it shows my appointment times for the day. When you click on the Week Tab it changes to a Week view, then on the Month View this would change to a Monthly view of the appointments. I know it sounds like a lot but if you look over the files I have attached and I think someone with the knowledge of Excel will be able to complete this task in a few days.

Excel Microsoft Office

Project ID: #8435160

About the project

13 proposals Remote project Active Sep 10, 2015

13 freelancers are bidding on average $153 for this job

zExcel

A proposal has not yet been provided

$200 USD in 3 days
(243 Reviews)
7.5
someka

You dont need to recruit me to finish this. Drop me a message, and lets see what i can do for you. If you get happy, we can progress. (as i need some good references in my profile, i provide this service) I have a 5 More

$122 USD in 1 day
(100 Reviews)
6.6
aarifakhtar

Hi: I have a few questions: Can you please share all the views of the calendar. There is only one attached file? It would be great if you could draw a mock-up of the appointment tab that you want. Please note that I ha More

$200 USD in 5 days
(116 Reviews)
6.6
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$150 USD in 10 days
(88 Reviews)
6.0
kevivu

Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv More

$133 USD in 3 days
(67 Reviews)
5.7
TonmoyRoy111

Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Ki More

$111 USD in 5 days
(106 Reviews)
5.4
dviruki

Dear Sir/Madam, I have 12 years of experience in automation of spreadsheets in Excel. I've completed a number of projects on Freelancer, involving VBA/macro coding in Excel, including calendars and order processing spr More

$138 USD in 5 days
(66 Reviews)
5.4
rajafaizan

I am very interested in working online for you. I am interested in long term work. I have had 5+ years exp. in Computers, MS word, MS excel, Quickbooks, Office Management , PDF, Google spreadsheet Powerpoint, Vba and t More

$134 USD in 3 days
(26 Reviews)
4.4
surekash7096

I have the expertise in Excel and the experience in creating a calendar in line with the specifications that you have provided. Ready to start work immediately

$155 USD in 3 days
(52 Reviews)
5.0
Abbadwajid

I am a CAT (Certified Accounting Technician) and ACCA (Association of Chartered Certified Accountant) qualified, pursuing CFA (Chartered Financial Analyst). Hence, I have extensive knowledge of finance, accounts, audit More

$105 USD in 3 days
(5 Reviews)
3.2
Davidxl

Hi, I've currently got a functioning MS Excel spreadsheet with a calendar that performs some of the tasks you need already. As it stands, you can input appointment types, client names, and dates on one page and they w More

$166 USD in 14 days
(2 Reviews)
2.1
pushar71

hello please connect with me i have been working on excel since last several years and have doen similar tasks in the past. i am online to discuss and conclude Puneet

$277 USD in 3 days
(1 Review)
1.8
ReneRondon

Hello. I am bidding for this project because I am an Accountant with lot of experience in Microsoft Excel. I'm very skillful in this tool, so I guarantee you an accurate job, proper design and fast delivery, all this i More

$100 USD in 3 days
(1 Review)
0.0