Noob here- best approach to extract personal schedule based on an employee schedule sheet,

Hello everyone,

Sorry I'm a total newbie to advanced excel offers and so I'm sorry if this is the wrong forum. I am starting work at a company and just got my schedule. The scheduler sends us a large monthly schedule listing what project (eg Facebook, Twitter) an employee is working on every month. I have attached an example of the schedule, which is much larger and has more employees, but this is the template sheet.

1) My question is, lets say I am employee N, is there a way to extract my own personal schedule automatically? This would be useful to other employees and automating this will make it faster and easier. I have spent hours reading about Pivot Tables, V/HLOOKUP, and finally macros and VBA but unfortunately am not smart enough to decipher what the approach is to best for answering this question. Could you help?

2) Once I have this figured out I plan to incorporate information from other worksheets. Another worksheet is for example a list of all the weeks of approved vacation listed chornologically and the employee's names next to them. Is there a way to extract that build it into my personal schedule?

Thank you all for your time and help!

Sample.jpg

As you were not able to decipher what the approach is to best for answering this question we are also not able to do that based on this text and picture only

we have expertise in Excel but not in deciphering pictures.


Please attach a sample excelfile that is desensitized of personal or business confidential data but still a good representation of current workbook in use. please also include a sheet to show how you think the new situation should look like.
Only that way we can help you solve your question

Hi and welcome.

It would be helpful if we could see what your expected outcome is.

If you can manually mock that up and attach the workbook (not a picture) you'll get help much quicker.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

BSB

Thanks for the feedback everyone, attached a excel file with the sample rotation schedule, vacations, and the outcome I was hoping for. Thanks!

Yes, understood, I went back to edit my post but it said "You are not allowed to post any kinds of links, images or videos until you post a few times."