+ Reply to Thread
Results 1 to 2 of 2

Event spreadsheet needs a calendar

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    Washington State
    MS-Off Ver
    2010
    Posts
    13

    Angry Event spreadsheet needs a calendar

    Hello friends!

    Just joined the forum because I've had a heck of a time figuring this one out. I have been slated with the task of making a calendar by pulling the data from this *joyous* event spreadsheet someone created before my time here.

    I would like for future users of said spreadsheet to put in their information as usual and have a macro(s) that will fill out the calendar as they input data- so I don't have to do it. I just need the Start/End dates, Event, and Venue to appear on a monthly calendar.

    I will be cross-posting the spreadsheet in the general forum for suggestions on how to make it not so... imposing. I really want to make it an Access database (which would do all this for me) but apparently, they're very attached to this monster.

    Help is most appreciated!

    J
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Event spreadsheet needs a calendar

    The dates need to be put in more consistently - what does Spring 2016 mean? Does Sept/Oct 2015 mean from 1st Sept to 31st Oct 2015 ?

    It's relatively easy to generate a calendar from a list of events, but the dates do need to be proper Excel dates. Check out the attachment in Post#7 of this thread from earlier:

    http://www.excelforum.com/excel-prog...-calendar.html

    which uses formulae to expand the date ranges to individual dates and then puts the "event" (in this case the name of the person booking leave) onto the appropriate day(s) of the calendar.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Event calendar with recurring event
    By glnorton in forum Excel General
    Replies: 2
    Last Post: 11-05-2014, 04:42 PM
  2. Event Calendar - Recurring event and filter
    By glnorton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-01-2014, 07:57 PM
  3. Excel spreadsheet holiday to Outlook Shared Calendar and update spreadsheet
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2012, 06:04 AM
  4. event spreadsheet to calendar form
    By roxannmoeller in forum Excel General
    Replies: 4
    Last Post: 02-06-2012, 01:43 PM
  5. Replies: 0
    Last Post: 10-31-2011, 10:58 PM
  6. Event planner, calendar, pop-ups
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2011, 05:14 AM
  7. Calendar event notifications
    By Dan Mackman in forum Excel General
    Replies: 23
    Last Post: 08-06-2008, 06:58 AM

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