Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: calendar

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Arizona
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to create a tool that includes a printable one-month desk calendar. The days need to populate from entries in a list with the fields, "Date" & "Event". Multiple events (up to 12) can occur on the same day, and events will not always be entered in chronological order. Any suggestions on an approach? (A vlookup for date values equal to the day on the calendar seems inadequate since it would need to return multiple entries and the entries are not in order).


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jeff,

    could a pivot table achieve what your after ? How about a Gantt Chart ? (there's an example in the tip-of-the-day files here on Mr Excel.... something I later used to schedule out my monthly duties and dates at work)

    [I assumed it was free]


    :: Pharma Z - Family drugstore ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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