Auto Populate Calendar based on rental dates

Hi,
I own a rental shop, and we do many different rentals on a monthly bases. I was wondering if there is anyway of taking only some information put on a tracking sheet(Pick up date, Name, Amount Owing) and have it auto filled into the calendar so my employees don't miss anything going threw the spread sheet.
My Goal is only to have one sheet to entire the full information on, from that the calander will update. that way i can keep it simple on a calendar for everyone else not in administration.

Can Excel even do this? If anyone knows an if() statement or other formula that can work for this please let me know!


Thanks.

Questions:

How many rental pickups per day (average) are you anticipating ?

Rather than a calendar, could it be a simple list with the dates separated (the employee only can only see "today")?

Will all of the scheduled pickups be noted on the calendar / list prior to the date of pickup or will there be last minute changes ?

Pardon the next question:

If the employees can't be depended upon to run a computer to check a database ... are they able to refer to a spreadsheet ?
Maybe a simple paper list would suffice ?

It varies based on the month sometime it could be 2 sometime if could be 50 to 100. I was hoping for a speadsheet that could populate the calaner based on date enyered so there for I'm not limited on entries.
And proper business should always have a "dummy proof" System so that is what I'm trying to put in place. Its just good organization if everyone(even the dummies) can figure out the system that's all but i appreciate the question no harm in that

it could be 2 sometime if could be 50 to 100

The 50 to 100 number tells me this should not be a 'traditional' calendar.

-- Are you ok with one tab (a single sheet) for each day of the month ?
-- The first sheet can be an INDEX page with hyperlinks to each tab / day of the month
-- Each sheet would have a corresponding hyperlink back to the INDEX sheet
-- Only the current date selected would show & all other sheets would be hidden until selected from the INDEX

I believe it could be constructed with a form for entries that are transferred to sheet and auto-sort by time of the day if needed.

Please Login or Register  to view this content.