+ Reply to Thread
Results 1 to 3 of 3

Create Monthly Calendar from an Excel of data

  1. #1
    Registered User
    Join Date
    01-15-2020
    Location
    DC
    MS-Off Ver
    recent
    Posts
    1

    Create Monthly Calendar from an Excel of data

    Hi -
    I would like to sort out a function that would take a list of dates and create a monthly calendar with those dates (labeled) on their correct day of the month.
    I've been digging around on the forum, and I'm not getting it - help
    I've posted a picture of the lists of dates.
    The goal is to maintain the list, as I make updates (change dates), I can refresh the calendar and the updates will be there.

    Screen Shot 2020-01-15 at 7.09.53 PM.png

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,168

    Re: Create Monthly Calendar from an Excel of data

    It would help if you attached a sample Excel workbook.

    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.

    Do NOT try to use the Paperclip icon (Attachments button), as this does not work on this forum.

    Your sample file should try to explain what data you have and what you want to do with it, maybe with a Before and After sheet to make it clearer.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,962

    Re: Create Monthly Calendar from an Excel of data

    See attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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