+ Reply to Thread
Results 1 to 4 of 4

Calendar and Deadline List

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Cleveland, OH
    MS-Off Ver
    2010
    Posts
    2

    Calendar and Deadline List

    Hi there,

    I'm looking to make a seamless calendar that then lists the information off to the side by date, too. I have my calendar set up. I'm looking for a way to have Excel look at the day, notice if there is anything in the cells that make up that day (each task is its own cell), and if so, populate to the list on the right side (example shown). If not, Excel should go to the next day. Is there a way to do this? Would it be better to do a VLOOKUP somehow and build information in a separate sheet?
    Example.png

    Thanks in advance!
    Attached Files Attached Files
    Last edited by emf893; 12-04-2019 at 01:49 PM.

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

    Re: Calendar and Deadline List

    Are you saying that you enter data directly onto the calendar and that you want to produce the list from it?

    I have several calendar files which work the other way round, i.e. you list events and dates on one sheet and then a calendar sheet places those events on the appropriate day of the calendar (for which month and year can be selected via drop-downs), with up to 10 events being displayed for each particular day.

    It would help if you attached a sample Excel workbook, explaining what you want to achieve.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-04-2019
    Location
    Cleveland, OH
    MS-Off Ver
    2010
    Posts
    2

    Re: Calendar and Deadline List

    Thanks! It is attached now.

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

    Re: Calendar and Deadline List

    Are those colours added manually? We can't do anything with a formula to use the colour (pink) to determine if an entry should be included on your Deadline list - is there some other way to indicate that an entry is a deadline item?

    In your example file all the deadline items occur on a Friday - will that always be the case?

    As an aside, I was wondering how you would amend the calendar for other months going forward, as there are no formulae in it to generate it automatically from a start date. Would you manually set it up for a new month each time?

    I do think it would be easier to set it up the other way around, i.e. use a different sheet to record in any order all your activities (including holidays etc.) and to indicate what type of activity it is, i.e. D for Deadline, H for Holiday, P for Published, E for Event etc. and then you could use these codes to set up conditional formatting automatically on a calendar sheet, where the details would appear on the correct day for the chosen month and in the appropriate colour.

    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. Replies: 1
    Last Post: 08-17-2015, 05:02 PM
  2. Replies: 3
    Last Post: 07-29-2014, 01:20 PM
  3. Help please for deadline.. forumlas!
    By jodieduncan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2013, 02:02 PM
  4. Deadline Formulae
    By jammy1812 in forum Excel General
    Replies: 9
    Last Post: 07-13-2011, 10:33 AM
  5. Calendar: deadline formatting
    By reddick.ross in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2010, 05:03 PM
  6. [SOLVED] Deadline Notice
    By roy.okinawa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2006, 06:40 PM
  7. [SOLVED] Active Deadline
    By Willamina in forum Excel General
    Replies: 5
    Last Post: 04-09-2005, 03:08 AM

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