Generate individual schedule from overview

[Kryddost]

Hello!


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!

 

[jim may]

Welcome to the Board.

To assist you, It would be best for us to view a small "sample" of your large worksheet with data filled in. Then also
for you to provide a sample of your "input" and expected "output".

Jim

 

[Kryddost]

Thank you, Jim!

I'm not allowed to attach files which makes the whole thing a bit harder. I uploaded externally now which I hope isn't breaking any rules: https://ufile.io/6t3vk

And I'm just getting started which means I don't have any real input/output yet, just a framework.