+ Reply to Thread
Results 1 to 1 of 1

Event Calendar from a List with Links and Bars

  1. #1
    Registered User
    Join Date
    02-03-2020
    Location
    asd
    MS-Off Ver
    2016
    Posts
    1

    Question Event Calendar from a List with Links and Bars

    Hi everyone,

    I am preparing a calendar that takes information from a event list. Now, I can show events on this calendar by city, date and name. The problems are

    1-) If a event has 2 or more days, it is showed on calendar separately. (Like 3 days-event has it's name in every one of B3-B4-B5). I want to make a bar for it (B3-B4-B5 has to be merged and this merged cell has to event name)
    2-) There is no links between calendar and list. So, I want to put a link for every event. When you click on the name of event on calendar, it will take you the cell of that event on event list sheet.

    In attached excel, Sheet Calendar shows currently calendar I made, Sheet List shows events lists and informantions, Sheet Need shows what I need at the end.

    P.S. : Calendar has been made by using macro, you can find it at macros, named as Calendar

    Thank you.
    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. Calendar - Inset event
    By BRENDOW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2017, 10:10 AM
  2. Event spreadsheet needs a calendar
    By maurerjl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2015, 08:03 PM
  3. Event calendar with recurring event
    By glnorton in forum Excel General
    Replies: 2
    Last Post: 11-05-2014, 04:42 PM
  4. Event Calendar - Recurring event and filter
    By glnorton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-01-2014, 07:57 PM
  5. Event planner, calendar, pop-ups
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2011, 05:14 AM
  6. Disabling command bars on worksheet activate event
    By ramserp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2010, 03:40 AM
  7. Calendar event notifications
    By Dan Mackman in forum Excel General
    Replies: 23
    Last Post: 08-06-2008, 06:58 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