+ Reply to Thread
Results 1 to 6 of 6

Use CSV data to populate calendar cells

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Wink Use CSV data to populate calendar cells

    Hi,

    Looking to have a sheet with three columns: Num(four digits), Start Date(Date+Time), End Date(Date+Time), populate a calendar on a seperate sheet.
    Sample Data
    Num Start Date End Date
    4123 11/24/2014 8:00 AM 12/5/2014 8:00 PM
    Ideally I would like to have a sheet with the raw data and then on a separate sheet a calendar with big boxes, the "Num" in the corresponding Start and End dates with a coloured line between the two.

    What is the best way to go about creating this?

    Everything I find on google is for a drop down date picker calendar, not how to actually make a calendar using the cells and insert data and formatting into them.

    Thanks,

    Alain!

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Use CSV data to populate calendar cells

    You're searching google wrong. Split your query into seperate problems and search for them not you desired result.

    Are you wanting VBA to create the calendar or just have a ready formatted calendar that is then populated by VBA?

    Do you need the calendar to be day specific ie January 1 appearing in the 5th column or are you happy to just run from 1/1 being in column 1?
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Use CSV data to populate calendar cells

    This isnt as straight forward as I 1st thought either, in your example are you wanting 4123 to appear in the boxes for 11/24 and 12/5? with an actual line being drawn diagonally over the calendar joining both of those dates? as in attached?
    Attached Files Attached Files
    Last edited by pjwhitfield; 11-20-2014 at 05:37 PM.

  4. #4
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Use CSV data to populate calendar cells

    I hope you havent disappeared otherwise Ive just wasted a lunch time!

    Based on the last post ive added a working version, enter the values in Sheet2 and press Run which will update the calendar in Sheet1
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Use CSV data to populate calendar cells

    Hi pjwhitfield,

    I have not disappeared and what you ahve provided is incredible! I can definitely use this as a template and continue to work with it.

    I did not explain the "Line" aspect clearly enough, for which I apologize. My goal is a quick colour based visual representation of the days between the start and end. Using your workbook as an example instead of actually drawing a line, we would instead change background colour of the cell. That way you can quickly look at the calendar and see "4123 starts on Jan 02 and runs to Jan 05, this is easy to see because the start and end cells as well as everything in between are all the same colour. ***I'm thinking put the start end dates in and do conditional format and move across cells adding the bar until end is reached, just not sure how I'm going to do this. Also if there are multiple activities with the same start and end I need to accomodate that...

    I was overzealous in thinking perhaps someone has successfully done this before and happen to be on the forum to read my post, how self centered of me haha

    Ultimately I believe I need to:
    1) Figure out how to make a calendar in Excel (Using Template or VBA) - Your Workbook is actually very helpful for this! Thanks!
    2) How to add the start and End dates to the appropriate cells - Again your workbook solves this for me! Thanks!
    3) Place a formatting line in all cells between start and end...

    for 3) I think I will use lets say 10 rows in one Calendar Box, that way I can have a max of 10 activities on one day and can easily format the background colour.

    Thanks for all the input everyone, I'm ready to give this a go. I appreciate all the feedback it has really helped me to get on the right track!

    Thanks,

    Alain

  6. #6
    Registered User
    Join Date
    11-12-2018
    Location
    Flower Mound, Texas
    MS-Off Ver
    2016
    Posts
    1

    Re: Use CSV data to populate calendar cells

    I have the same basic issue. I need to create a calendar that shows the start and end dates for a project, that show up highlighted. I also need to show holidays. So is there a way to show the holidays with a say "green" background, then list multiple calendar items on the same day? I want to show the calendar on the same tab as well.

+ 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. Requesting help with a calendar that will auto-populate from a data set
    By rachy894 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2014, 02:50 PM
  2. [SOLVED] Shade Cells and populate list in Excel calendar
    By staysecure in forum Excel General
    Replies: 7
    Last Post: 01-04-2013, 11:07 PM
  3. Replies: 2
    Last Post: 06-14-2012, 01:55 PM
  4. Auto Populate Data into Calendar
    By nancyching1711 in forum Excel General
    Replies: 4
    Last Post: 04-22-2012, 12:42 PM
  5. A single Calendar macro that can populate multiple cells?
    By Codpops in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2008, 08:27 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