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.
Bookmarks