Results 1 to 3 of 3

Populate a calendar from a table

Threaded View

  1. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Populate a calendar from a table

    I don't think your choice in calendar is ideal. If you're trying to implant relevant text into the actual calendar, having each calendar date equate to exactly one cell makes populating the cell with both the formula for the date and the formula for the text (if any) awkward, at best. I would advise sifting through Excel's templates for something that fits better. There are calendars specifically designed for this kind of thing that I couldn't track down, but even a basic family calendar can be combined with your "Calculator" page and some INDEX/MATCH formulas to do the trick. I threw together a quick sample to show what I mean. I input the necessary formulas into the sheet for 'May' so you can see how it looks. You can copy that setup into the other months. Again, though, it'd probably be worth your time to peruse the free templates that already exist. Easier options exist out there.

    (I had to delete every month except Jan and May to get the file size down to a level that I could upload, but the entire calendar is available as a template)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Populate Calendar from Table Excel
    By Corocotan in forum Excel General
    Replies: 15
    Last Post: 12-10-2020, 02:13 AM
  2. [SOLVED] Populate a calendar from a table
    By Gerard.GRC in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-05-2015, 11:53 PM
  3. 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
  4. Populate monthly calendar with table
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-08-2014, 04:18 AM
  5. Replies: 2
    Last Post: 04-01-2014, 09:24 PM
  6. Auto Populate Calendar From Data Table
    By tommy_b in forum Excel General
    Replies: 2
    Last Post: 10-28-2013, 06:04 PM
  7. Replies: 0
    Last Post: 04-25-2011, 04:28 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