+ Reply to Thread
Results 1 to 2 of 2

Filtering events in Excel calendar

  1. #1
    Registered User
    Join Date
    01-28-2020
    Location
    Auckland, New Zealand
    MS-Off Ver
    Microsoft Excel for Office 365 MSO on Windows 10 Enterprise
    Posts
    1

    Filtering events in Excel calendar

    Hi there, this is my first post so I hope I am posting in the right area and able to articulate my problem clearly.

    CONTEXT
    I am an Executive Assistant who works for an Executive who attends numerous monthly meetings, annual conferences and travels regularly both domestically and internationally. At the beginning of each calendar year we sit down together to plan the year which includes setting key financial and meeting dates, and travel dependent on other important activities e.g. conferences and his own holidays / annual leave. What I have always done in previous years is download an excel calendar template and input all this data. I input the data by selecting a color for each "event" type and filling the cell with this color (I remove any colors that the template may use and make it as basic and clean looking as possible). It is important that the entire year is visible in one glance as we often work a few months ahead and the entire year often needs to be taken into consideration at any one time. The calendar template that I have been using is just a basic excel file on calendarpedia
    PROBLEM
    The problem that I have encountered is that often the calendar is showing too much information, with many "events" on one day and it becomes difficult to read and pull out the key information I am focused on. I would like to find a way where I am able to have a drop down box where I am able to select which type of events appear at the calendar e.g. Meetings (which would include Board Meeting, Executive Meeting and would have to have their own colors) Travel (which would include Domestic Travel and International Travel which would also both require a different cell fill color), Conferences, Annual Leave, Company Wide Events etc. It would also be necessary to be able to view all events as well. The further issue that I have is that often there are days where my boss will have multiple key things happening e.g. He is on an overseas trip, attending a board meeting. Is there any solution where I am able to keep the format of the calendar relatively the same?

    Any help would be so greatly appreciated.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Filtering events in Excel calendar

    Administrative note

    Hi and welcome

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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. Replies: 4
    Last Post: 11-11-2019, 01:42 PM
  2. Using Excel VBA to Add events into Google Calendar
    By AV114 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2018, 06:10 AM
  3. Excel Calendar to track events
    By X82 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-28-2018, 09:09 PM
  4. Auto populate events to excel calendar from a list
    By lridley2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2016, 05:22 PM
  5. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  6. Add recurring events to an excel calendar
    By Kaitken123 in forum Excel General
    Replies: 0
    Last Post: 09-28-2014, 08:55 PM
  7. Populating an Excel Calendar to Reflect Ongoing and Future Events
    By Lruegg in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-30-2012, 07:20 PM

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