Interactive Calendar with sheet for each day?

[harbour1302]

Probably a long shot.

I haven't created anything yet was just interested if this was possible.

I would like a calendar, full year on single sheet.

I would like to be able to click a date in the calendar for example click 23rd May and have a sheet open in which i would store business results for that day. If possible also have a summary box appear when hovering over the day.

I've looked online for templates, i have a very basic knowledge of VBA.

Can anyone point me in the right direction or tell me if i'm attempting the impossible?

Thanks

 

[Legacy 143009]

Probably a long shot.

I haven't created anything yet was just interested if this was possible.

I would like a calendar, full year on single sheet.

I would like to be able to click a date in the calendar for example click 23rd May and have a sheet open in which i would store business results for that day. If possible also have a summary box appear when hovering over the day.

I've looked online for templates, i have a very basic knowledge of VBA.

Can anyone point me in the right direction or tell me if i'm attempting the impossible?

Thanks

Ok then have a main worksheet and create new ones for everyday. Right click to date and select Create link. On the left pane menu select "in this work book" and refer to desired date's sheet.

Customize the sheets however you need.