Results 1 to 2 of 2

Thread: Synchronize excel calendar with dates

  1. #1

    Synchronize excel calendar with dates

    Register for a FREE account, and/
    or Log in to avoid these ads!


    Here is what I am looking to do: on one sheet of my workbook is an activity log. Users will plug in a date and in the next cell they will record an activity. On the second sheet I would like to have a yearly calendar. When the user plugs in, say 1/1/2012 and logs activity, the calendar will update. After logging an event, that date's cell will change colors on the second sheet.

    On 12/5/2012 an employee was absent.
    The cell for 12/5/2012 on the calendar is now filled in red.

    On 12/1/2012 an employee was tardy
    The cell for 12/1/2012 is now filled in yellow.

    Any thoughts on how to accomplish this?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    If you're looking to capture data from one input cell and log it, you'll need a macro to do this. Let us know what cell the data is being captured in, where the "calendar" range is, and where you'd like the data pasted. (I.e. one column to the right of the date?)

    To highlight the data in the calendar, you'll just want to set up a conditional formatting rule.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts