Hi,

I have two different sheets called Monthly Events and Weekly Events which contains event names and event dates. I want to have all these as a list on third sheet. Sorting is not important. But for each date the event name should be there. That is important. I do not want any macros just functions as all my colleague computers has high security option enabled based on company policy. I made this happened only after making six different columns on consolidated sheet and getting the data from both sheets. Then combining this data. But I want to eliminate this extra process. Can this be possible?

Sample sheet.xlsx

I made like this which is a extra one

Sample sheet my way.xlsx

Any help is appreciated.