+ Reply to Thread
Results 1 to 2 of 2

If Then / Offset Formula [populate calendar from a list of events]

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Council Bluffs
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question If Then / Offset Formula [populate calendar from a list of events]

    I'm not sure if this is possible or not, but I'm trying to create an employee calendar that populates from information entered into vacation spreadsheet. The vacation table lists employees, name, date, hours off, type, and time requested. I'm trying to get this to populate into what looks like a regular monthly calendar but only show the time requested and their name behind it for each person requesting time off. (UNLESS SOMEONE HAS ONE ALREADY BUILT AND WOULD BE WILLING TO SHARE.)

    I'm not 100% savvy on how to do it, but I basically want to take everyone who requested time off on a given day and populate that data to the corresponding day on the calendar.

    This is definitely the long way around it, but I was able to do the following formula below in my calendar for each person: If cell xx in the calendar is empty, then nothing. Otherwise return time off and name. I then made this formula in the calendar itself for each person changing the last cell reference. I was able to get day 1 to work, but don't know how to copy it to other days so it knows to go Jan 1, Jan 2, Jan 3 etc.


    =IF(VacTable!D3="",0,VacTable!D3&" "&"-"&" "&VacTable!$B$1)

    Hopefully these images come through to show what have so far. It may be better to use VBA, but I'm not that saavy.

    Calendar.JPG
    VacTable.JPG

    There is also a second calendar worksheet that doesn't have separate lines ... just a spot for any text that could just return a text string with a hard return at the end.

    Any help is appreciated. Thanks in advance for your unbelievable knowledge!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,125

    Re: If Then / Offset Formula [populate calendar from a list of events]

    For each day same quantity of rows as quantity of persons
    then this can do

    Kind regards
    Leo
    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] Dynamic Offset Formula to populate a Data Validation list
    By TC1980 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-09-2017, 11:27 AM
  2. Replies: 1
    Last Post: 08-04-2016, 01:33 AM
  3. [SOLVED] Auto populate calendar from list of events in 2 tables
    By blndsjy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-03-2016, 05:07 AM
  4. populate events calendar from inputs
    By excelforum2k16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2016, 03:44 AM
  5. Auto populate events to excel calendar from a list
    By lridley2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2016, 05:22 PM
  6. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  7. Auto populate events in calendar on userform
    By imzhakmaya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 07:31 AM

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