+ Reply to Thread
Results 1 to 4 of 4

Custom scheduling calendar

  1. #1
    Registered User
    Join Date
    09-26-2009
    Location
    Pharr, TX
    MS-Off Ver
    Excel 2007
    Posts
    2

    Custom scheduling calendar

    Hello all,

    I created this calendar that is attached for a site I was hired to take care of. they hold graduate level courses in nine different classrooms, now they want me to be able to type in scheduling information on an another workbook and it be able to be automatically updated on the calendar I made. Can excel do this?
    for example: type in: Monday, Sept. 28, 2009 from 6:00 PM-9:00 PM in room 101, event: education course and in my calendar the corresponding cells will be filled in with the information.

    any help is greatly appreciated,
    Marco
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Custom scheduling calendar

    The Calendar isn't Dynamic at all so I imagine you are manually inputting the entries.

    The TextBoxes & merged cells are going to be a pain.

    You should be able to use VLOOKUP to populate the dates if the calendar was designed to be created with formulas not just manual input.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-26-2009
    Location
    Pharr, TX
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Custom scheduling calendar

    Thank you royUK,

    How can I make this calendar dynamic so do not have to input everything manually?

    Thanks
    Marco

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Custom scheduling calendar

    have a look at some Calendar templates available on the internet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1