How To AUTO Create New Worksheets For EACH Name And Subsequently Added Names In List
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!
Re: How To AUTO Create New Worksheets For EACH Name And Subsequently Added Names In List
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.