+ Reply to Thread
Results 1 to 2 of 2

How To AUTO Create New Worksheets For EACH Name And Subsequently Added Names In List

  1. #1
    Registered User
    Join Date
    02-27-2023
    Location
    Slovenia
    MS-Off Ver
    2301 build 16.0.16026.20196) 64-bit
    Posts
    1

    How To AUTO Create New Worksheets For EACH Name And Subsequently Added Names In List

    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.
    Attached Images Attached Images

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel macro to autofill a list and create new worksheets with names from the list
    By fms006 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2020, 05:38 PM
  2. Create new worksheets with names from a list
    By daniel_t in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 03:21 AM
  3. Auto populate list of names from various worksheets
    By shuttletech in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2011, 09:44 AM
  4. [SOLVED] Create a list in one worksheet of the other worksheets' names
    By Kelli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Create a list in one worksheet of the other worksheets' names
    By Kelli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Create a list in one worksheet of the other worksheets' names
    By Kelli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Create a list in one worksheet of the other worksheets' names
    By Kelli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1