fortnight_skyrim
New Member
- Joined
- Apr 14, 2018
- Messages
- 2
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!
http://tinypic.com/r/2qmi1qb/9
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!
http://tinypic.com/r/2qmi1qb/9
Last edited by a moderator:
