Hello,
To keep things brief and simple, I was put in charge of excel vacation planning and was given specific instructions on what to do to make it simpler and more time efficient in doing this work in the future. This task was set upon me by a higher up due to my "technical knowhow" even though the only experience I ever talked about in this field were piracy and basic photoshop. I was given specific instructions and it was made clear to me my job may be on the line if I failed to produce results. No matter how much I insisted I didn't have the basic knowledge in excel code and VBA, they refused to listen and assigned me this task. So this is why I'm here now. I provided pictures to make things as simple as possible to understand but the fact that I don't know anything remains.
I don't even understand how the code works and don't have enough of a time frame to learn the basics before my task is due.
If anyone is interested in helping in any measure, I will leave the details here:
Picture 1: The names you see partially marked over in column A (marked yellow) need to correspond to a tab with the same name. Any time a new name in added to column A it needs to auto generate a tab with its corresponding name.
Picture 2: The tab must keep the same table info as seen in this picture (marked purple) and must also autofill the name to its corresponding name (marked blue) on the sheet (marked yellow) from picture 1.
Picture 3: This tab (marked green) is made specifically to auto detect work free holidays so it doesn't take such days into account for vacation - hence the work free holiday. It's currently out of order (states time instead of dates) due to someone messing with it before they assigned me to this hellscape.
Picture 4: This is the VBA code that runs this currently.
Microsoft? Excel? for Microsoft 365 MSO (2301 build 16.0.16026.20196) 64-bit
I will appreciate any kind of help and am willing to further elaborate or provide needed material to find a solution!
Thank you in advance.
Bookmarks