Monthly Event Schedule (format like that)

Originally Posted by mikerickson

UDF's can't automaticaly add sheets, a Change event will be needed.
In the UDF, the variable eventDelimiter is set to vbCr. That line could be changed to vbCr & vbCr.

I'll take a look at your attachment after work. A change event testing if a new sheet is needed and creating it, including the formulas, is doable.

Hi Mike,

Now I just want to improve the UDF that allows a line break between each item: Event, Location, so on, and double line break between every event as shown below:

Event: ....
Location: ....
Time: ....
Audiences: ....
Person in charge: .....

Event: ....
Location: ....
Time: ....
Audiences: ....
Person in charge: .....

Event: ....
Location: ....
Time: ....
Audiences: ....
Person in charge: .....



The monthly sheet I will insert and rename it myself. Not necessary to use the button.

Hope you help me little bit more to complete such UDF.

Thanks,