Could someone help me to use Excel Formula to create Monthly Event Schedule as shown in the Sheet named "January 2010" in the attached file?
The Monthly Event Schedule is automatically generated from the Sheet named "Master_Plan".
As when the user inputs data of every events and inserts new Sheet, renames the Sheet with a name of a certain month of the year 2010, the Monthly Event Schedule is generated as well as updated by linking with the Sheet "Master_Plan".
I have do somethings already but can not continue to input formula to create the Monthly Event Schedule with the format like that.
Hope someone could help me!
Bookmarks