Worksheet that Mirrors a Table

[nawdrizzy]

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.

 

[mikerickson]

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?

 

[nawdrizzy]

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.

 

[mikerickson]

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 )

 

[nawdrizzy]

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.