Excel calendar with Appointment. Is this doable?

Hi guys,

I have roughly around 25 appoinmets each month and I am currenly using excel spreadsheet to record & trach all my appoitments.

I am wondering if it is doable to crete an excel spreadsheet calendar which will automatically update my appoiments (shws client's name on each appoinment date on the calendar). Please see attached the excel sampl file below.

Can someone please at least provide me a link to where I can find relevant info or sample file?

Thanks.

Take a look at this thread:

http://www.excelforum.com/excel-new-...readsheet.html

The attachment will do what you want without using macros.

Hope this helps.

Pete

Hi Pete,

exactly what I was hoping to achieve!! I never thought it would be doable only using functions, not macro!!! Amazing stuff. Thanks!!!