• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Show Calendar

MissyS

MissyS

New Member
Hello! I work in an industry where we visit many trade shows per year. These shows effect the availability of pricing specials for our customers. The Customer Service department would like a calendar printed that visually helps them see the block of time (so standard calendar view) that the shows take place so they can track forwards and backwards as needed.

I would like to be able to use the attached for format/look (which would be based on Chandoo's standard 2010 calendar) to somehow have events automatically fed in so the date blocks are colored and the name of the event is listed (similar to an Outlook calendar but upkeep in an Outlook calendar has been tedious and our IT won't allow me to grant universal access for everyone to view).

Has anyone done anything like this before? I don't want to reinvent the wheel... I looked at Chandoo's Pivot Calendar but that didn't look like it would result in the what I'd like to see.

Thank you!
MissyS
 

Attachments

Hi ,

What you want can certainly be done using VBA ; is this an option ?

In order to code this , you need to specify where you will enter data , and where you want the dates coloured , and in what manner ; will just one colour for all events do ?

Narayan
 
Hmm... well, I don't really know anything about VBA but it's one of the things I've really wanted to learn. So maybe I'll make this my first project to fiddle around with it. And yes, one color will do. They'll be printed in grayscale.

Any suggestions on where to start educating myself please? Thank you!!

Missy
 
Hi,

Just to take an idea. Are you trying to highlight dates of event listed in the list on calendar? Are the event list will be updated manually. ?

Regards,
 
I will have to update the list manually since the show dates change annually but I want the events highlighted on the calender like you would see in Outlook but sharing an Outlook calendar is very difficult. I want others to be able to add to the list as well.
 
Thanks! That's awesome! I appreciate it. I'll have to play with that and see what I can learn from it. :)

I actually need to take it to the next level so the blocked out dates are on the full calendar page tabs with the name of the events listed. But I want to learn so I'll play with what you've given me. Thank you!!!
 
You must log in or register to reply here.
Back
Top