+ Reply to Thread
Results 1 to 2 of 2

dynamic calendar based on registry in table

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    1

    dynamic calendar based on registry in table

    please help
    I have a table with travels of people on business. With start date and end date , name of person, destination etc.
    I want to create a dynamic calendar . separate worksheet with matrix where I have in column A the names of all the people and in first row the calendar dates.
    For each cell in that matrix I need to have an (*) if that person (his name is in corresponding cell A$x) traveled on that date. I kind of need to vlookup in the above mentions table and see that the date is between the start and end dates of one of the travels that man did, and then put and asterisk (*) in that cell to mark it. I thought to create a formula that will kind of create a dynamic array of all the travels of some person and check that the date of the particular column is in the range.
    thanks

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: dynamic calendar based on registry in table

    Hi dadarara;

    see if this gets you started Travel Dates.xls
    Type dates into columns B & C (between 1/1/10 & 9/12/10), then go look at the calendar sheet to see if that's what you're looking for.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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