+ Reply to Thread
Results 1 to 2 of 2

Populating a calendar with info from a table

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    US
    MS-Off Ver
    Excel for mac, v16.50
    Posts
    1

    Populating a calendar with info from a table

    All,

    I have a table with some specifics for a series of jobs that may either be running concurrently or consecutively.

    What I'd like to is to link the data in the table with a calendar in another tab.

    The file that I attached has a sample table with a calendar showing how I'd like to be able to see the data. The only pieces that have to come over are the Job ID and the dates. I would really love to be able to see the Job IDs highlighted and color coded. For example, job 4321 would be yellow, 1579 would be another color, 1234 another, etc. But that would all be the gravy on top and is not necessary.

    There could be as many as 10 jobs taking place on any given day.

    This is sort of a big ask, but I am over my head on this one. A completed book would be marvelous, but I'm open to suggestions and help as well.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: Populating a calendar with info from a table

    Hello bcc1579 and Welcome to Excel Forum.
    As there could be 10 jobs per date, this proposal employs 10 rows per date on the calendar.
    The rows under each date on the calendar are populated using formulas similar to:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 3
    Last Post: 09-10-2019, 02:16 PM
  2. Populating a Calendar with certain info!!
    By kygore in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-18-2016, 04:29 AM
  3. Populating a Table based on info appering in another cell
    By Paul GF in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-18-2013, 07:17 AM
  4. Populating a Table based on info appering in another cell
    By Paul GF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-18-2013, 06:46 AM
  5. Populating a Calendar from an Excel Table - Resource Planning
    By chriswalker82 in forum Excel General
    Replies: 0
    Last Post: 12-04-2012, 08:11 AM
  6. [SOLVED] Auto Populating Info from cells to a calendar by date
    By mitchellm203 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-30-2012, 08:36 PM
  7. Populating info from pivot table
    By extrudebg in forum Excel General
    Replies: 3
    Last Post: 05-01-2012, 11:52 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