+ Reply to Thread
Results 1 to 2 of 2

Auto-Populating Excel Calendar

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Auto-Populating Excel Calendar

    Looking to create a calendar in excel and auto-populate the content with specific fields I enter. Someone showed me how to create an excel gantt chart but I’m really looking for a calendar view instead of a series of columns with dates. I reviewed the original post on Auto-Populating Excel Calendar but was confused by the instructions. Can someone please help me to (1) create a calendar in excel and (2) show me how to populate the calendar with fields like (dept and project name) into the dates on the calendar? I have two dates that are important (a due date for the project and when that project will be published). Is there a way to have both dates show info otherwise the most important date will be the publish date?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Auto-Populating Excel Calendar

    Welcome to the Forum excel_help1!

    Here is an implementation that puts a rolling three-month calendar on another sheet. The calendar starts based on the earliest event you have. If you want to advance the calendar you have to delete (or archive) the earlier dates.

    This only handles one event per date. If you have multiple events per date, it stops on the first one. This may not meet your needs. If you need multiple events per date, it needs more complex formulas or VBA code.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. auto-populating event excel calendar
    By mmctague in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2015, 10:29 AM
  2. Auto-populating a calendar with multiple dates
    By lamct in forum Excel General
    Replies: 2
    Last Post: 07-20-2013, 05:16 PM
  3. Questions about auto populating calendar
    By Corocotan in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-18-2012, 02:47 PM
  4. Auto-populating a calendar based on two variables
    By emfc00 in forum Excel General
    Replies: 1
    Last Post: 04-17-2012, 09:59 AM
  5. Auto-Populating Excel Calendar
    By Vbort44 in forum Excel General
    Replies: 27
    Last Post: 11-16-2011, 03:43 PM

Tags for this Thread

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