We have an Advertising Calendar which shows when our confirmed marketing events will happen.
At the bottom of each month’s page, my boss would like a separate list web part that filters to show only upcoming, non-scheduled items for that month (from another list).
For example, when you are in January on the Advertising Calendar page, the second web part would show the info for all items in that list where a “Month” column matches “January”. If you switch to February in the calendar, then the web part would filter to show only items where the “Month” column matches “February” and so on.
Any idea on how to accomplish this?