+ Reply to Thread
Results 1 to 2 of 2

Calendar won't auto populate for start stop dates

  1. #1
    Registered User
    Join Date
    04-10-2019
    Location
    VA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Question Calendar won't auto populate for start stop dates

    I've been working on a shorthand calendar for my office's shared outlook calendar. We have too many people and too many things going on to printout the normal office calendar and when we can get it to fit it's too small to read well.

    my calendar works great when the events are only one day, but if they last longer it only shows the first day. I'm not sure how to work my code to change that.

    Also for some reason my vlookup function doesn't want to work when grabbing employee id numbers. It either gives me a #N/A or REF! error and I can't figure out why.

    I uploaded the calendar below.
    Thanks for any help.
    Attached Files Attached Files
    Last edited by rose8693; 05-15-2019 at 08:02 AM.

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Calendar won't auto populate for start stop dates

    Hi
    Some suggestions:

    1) Do not add an extra space to Employee name

    2) The VLOOKUP do note use the column number of Excel Sheet. Use the column of the range you pass to that function. So
    =VLOOKUP(AR2,$AI$2:$AJ$12,36,0)) must be =VLOOKUP(AR2,$AI$2:$AJ$12,2,0))

    3) Use Horizontal Alignment 'Center in selection' instead Merge cells whenever possible.

    4) Use the following formula in C4 and copy down and forward
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the file for clarification
    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)

Similar Threads

  1. [SOLVED] Auto-Populate Calendar Dates
    By ajlax4 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 12-05-2017, 04:11 PM
  2. Auto Populate Calendar based on rental dates
    By NickolasH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2017, 11:45 AM
  3. Replies: 1
    Last Post: 08-04-2016, 01:33 AM
  4. Replies: 2
    Last Post: 03-30-2014, 06:10 PM
  5. Auto-populate calendar dates
    By zturtles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 09:44 PM
  6. Auto populate vacation calendar dates per employee
    By boxermack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2013, 11:47 AM
  7. [SOLVED] How do I Auto Populate a Calendar Series per Start and End Date?
    By Inez15 in forum Excel General
    Replies: 3
    Last Post: 11-13-2012, 04:05 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