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!

    Hello.

    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.

    Example:
    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
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    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 (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/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
  •