Results 1 to 5 of 5

Thread: Worksheet that Mirrors a Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Worksheet that Mirrors a Table

    Hello,

    I was hoping that you could help me. I am trying to create this Employee benefit and vacation sheet which encompass all 12 months. Is there a way that I can create a table or something that will take the employees name and mirror to each worksheet (12 month), and if i add or delete an employee it will adjust the other worksheets accordingly without messing up the spacing. I tried both = and reference the employee and indexmatch and the problem I am having is that it will throw off the space if an employee is delete or added. Thank you in advance.

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,646
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Worksheet that Mirrors a Table

    You'll need to provide more detail about how these sheets are layed out.

    I'm also wondering what you want when adding or deleting employees.

    If you have a different sheet for Jan, Feb, Mar, ... etc and an employeee is hired or leaves in March, wouldn't you want their name (and history) to remain on the Jan,Feb and March sheet and any change be only to April and forward?

  3. #3
    New Member
    Join Date
    Aug 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Worksheet that Mirrors a Table

    Quote Originally Posted by mikerickson View Post
    You'll need to provide more detail about how these sheets are layed out.

    I'm also wondering what you want when adding or deleting employees.

    If you have a different sheet for Jan, Feb, Mar, ... etc and an employeee is hired or leaves in March, wouldn't you want their name (and history) to remain on the Jan,Feb and March sheet and any change be only to April and forward?

    The layout of the worksheet is that I have the employee names on column A:A and the data is being recorded for each employee on the corresponding row for each employee.

    When it comes to adding and deleting. I have the worksheet recording each employee by department. SO if i want to add someone into a department I wanted to be able to add it to one sheet and then all the other sheet would change base on that one change and it would automatically space out so not to mess up the other employee's data that's already there.


    And yea I do want the history and any the changes to be for only going forward. What i'm asking for may not be able to be done to the T, but i'm just wondering how close i can get to it.

  4. #4
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,646
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Worksheet that Mirrors a Table

    I'm at my dayjob and can't work on this, but the Add employee sounds doable (blank lines for their pre-employment months).
    How familiar are you with VBA. This sounds like a decent sized project. Are you doing it manually at the moment. (That works out a lot of user input bugs )

  5. #5
    New Member
    Join Date
    Aug 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Worksheet that Mirrors a Table

    Quote Originally Posted by mikerickson View Post
    I'm at my dayjob and can't work on this, but the Add employee sounds doable (blank lines for their pre-employment months).
    How familiar are you with VBA. This sounds like a decent sized project. Are you doing it manually at the moment. (That works out a lot of user input bugs )

    I am very familiar with running VBA's in my worksheets, but not in writing them. I have several VBAs in this worksheet doing different things suming colors. The only thing that is being done manually is added the emplyees and the data.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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