Generate personal schedule from overview

[Kryddost]

Hello!


I've attached a file to better explain what I'm trying to do. I'm using Excel 2016.


I have a large worksheet with weeks and days spanning a year. Each week is divided into days and and each day has initials to plan which person goes where at each day. What I want to do is build a second worksheet where I choose the person (initials) and hit a button to generate that persons schedule for each week. Is this possible? What I'm asking for is a hint or a little help as to how I should start, or even just what to google would be a great start!

[snb]

If you use an intelligent table you can filter on any item in any column in any combination; so you won't need a second sheet or macro.

[Kryddost]

Thank you for the quick reply, snb. How would I go about using intelligent table for such a huge document with both row and column headers? Do you have any preferred resources on intelligent tables?

[snb]

See the attachment