Creating a Calendar that autopopulates from multiple sheets Closed

Question

Hi all,

I am attempting to make a calendar that will auto populate or vice versa from multiple other sheets. This is all to track training hours for work. The sheets have 5 columns and depending on point in training there would be 4-9 sheets that the calendar would be drawing information from or populating to. 

I've seen some macros online to make a list of this basically, but I really need it in Calendar form ideally. If you can help me at all please let me know. 

Thank you

kadrleyn · Answer

I recommend you examine this sample file : 

Calendar With Event Planner (To-Do List)

            Data can be recorded with userform to selected date . Data on userform are transferred in the Excel sheet as automatically.     
http://static.ccm2.net/ccm.net/pictures/K0cKskDCGOghFvMWVXwaqmzp38WfumKXmQFxgngsm1FUmk87dHhBnbTgkhQacpyh-calendar-with-notes.png   
In this agenda example ,we used "Calendar Class"  instead of calendar control .
Calendar Control is an ActiveX Control and it gives error on some excel versions. The Calendar Class works in all version of Office VBA (Excel, Word, PowerPoint, Outlook)  

Calendar example can be watched and downloaded here: 
xxx

Creating a Calendar that autopopulates from multiple sheets

1 response

Similar discussions

Subscribe To Our Newsletter!