Hi,

I'm aware this questions has been asked before in many forms, however
I am looking for something quite specific.

I am looking to create and Outlook style calendar within Excel. I
cannot use the Outlook calendar, nor can I use any type of add in (due
to distribution).

I need a calendar that a user can view monthly, and weekly (and
possibly drill into for a daily view dependant on the below).

The user will need to see a printable weekly view, and store around 10
- 15 entries per day. The entries will be populated from selections on
other sheets of the workbook and all will have a similar format (NAME,
ADDRESS, ADDRESS2, ADDRESS3, POSTCODE, TEL, CONTACT,NOTES).

I have tried creating a basic weekly layout that can hold 15 entries
per day, however I cannot get all of the information above to fit into
the entries without the week being too large to print on one page.
This is why I feel I may need a daily view, so the user can view and
print the basics, (perhaps NAME / POSTCODE) from the weekly view, and
drill in to the daily view to see the detail.

I would prefer to have a rolling calendar (ie never runs out), however
at a minimum would like 18 months if the rolling calendar would be too
complicated. I do not want to use lots of sheets, and do not want the
old entries deleted (however would like them hidden and only viewable
if required).

I am comfortable coding / creating a calendar once I can get my head
around the logistics of how it would look / work. Any help or
suggestions would be appreciated as I am fairly stuck at the moment.