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.