+ Reply to Thread
Results 1 to 6 of 6

Dynamically create workbook for employee tracking

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Bluffton, SC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Dynamically create workbook for employee tracking

    This is my first post...so please forgive me if I mess something up. I was 'Googling' to try and find a solution to my problem and came upon this forum. I tried using the info I found in another post, but I lack the knowledge to modify it for my needs.

    What I have so far:
    Please Login or Register  to view this content.
    What I need to accomplish:
    Have management input employee name (Last Name, MI. First Name)in Sheet1!H3:AU3
    Create a page for each employeein H3:AU3 using Sheet3 as a template
    Name each newly created tab with the employee name (Last Name, MI. First Name)
    On Sheet4 use A13:I16 as a template and duplicate for each employee

    Sorry for the long post, just wanted to make sure enough detail was provided. Test.xls
    Last edited by DevilDog78; 01-18-2012 at 11:33 AM.

  2. #2
    Registered User
    Join Date
    01-18-2012
    Location
    Bluffton, SC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Dynamically create workbook for employee tracking

    Ok...I think I am getting closer
    Please Login or Register  to view this content.
    It dies at ActiveSheet.Name = Sheets("Sheet1").Range("H3:AU3").Value.

    It is copying the Template page and creating a new page. Now I need to get it to name the page, and continue creating pages for all enteries in H3:AU3.

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Bluffton, SC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Dynamically create workbook for employee tracking

    Awesome! I figured part of it out.
    Please Login or Register  to view this content.
    Now...How do I accomplish On Sheet4 use A13:I16 as a template and duplicate for each employee?

  4. #4
    Registered User
    Join Date
    01-18-2012
    Location
    Bluffton, SC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Dynamically create workbook for employee tracking

    I am slowly catching on. I have managed to solve quite a few of my questions already. Can someone looks this over and tell me what I am doing wrong?
    Please Login or Register  to view this content.
    I attached a copy of my sheet for reference. What I am trying to accomplish here is to set up the "Mngt View" tab based on the enteries in the Data Input tab. I need for each person listed on the Data Input tab in Range("H3:AU3") to have a box on the Mngt View tab to enter their Problems and a box for their accomplishments. I would greatly appreciate any help on this. I am currently spinning my wheels over here.

    Test.xls

  5. #5
    Registered User
    Join Date
    01-18-2012
    Location
    Bluffton, SC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Dynamically create workbook for employee tracking

    Ok...I have managed to solve that problem too. Now this one should be easy...but I have no clue how to even start. I want to enter formula's into specific cells. The formulas will be based on the individuals name. As an example, on the Data Input page, the manager will start entering employee names in H3 (Employee1). The manager will then enter all the CIO goals as they apply to the group starting in A4. The manager will then select the goals specific to Employee1 in H4:H39.

    At this point the employee already has their sheet created ("Employee1"). I now need to have the goals listed in H4:H39 (which are specifc to that employee) to fill in B31:Q31.

    Please someone help me out here.


    Test.xls

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Dynamically create workbook for employee tracking

    You said the goals would be listed in H4:H39..of which tab?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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