Sign in to follow this  
Followers 0
buzlink

Excel 2010 Manage list of employees acrross sheets

4 posts in this topic

Is there a way to manage a list of employee names broken out by department to have this same list update across other sheets in the workbook adding and deleting any changes to the employee list?

I am hoping to track a few metrics for each employee by each day for a month and then have this total update and track by each month for a year end total. Any suggestions on the best way to track this woudl be greatly appriceated as it is key to be able to add and delete employees and have this update across the other sheets.

Thanks.

Share this post


Link to post
Share on other sites

It would be better to use an actual relational database IMHO, instead of Excel, but I know it is tempting to abuse Excel. Our users do the same :)

What is the layout ? Do you have separate sheets for each department ?

If the layout is consistent, then you can make some VBScript functions that query across the sheets, tallying up your metrics and returning them just like the premade excel functions do. Basically enumerating all sheets with a certain tag in the sheet name, then iterating through all lines until the script finds a blank line, treating each row like a database row.

It is possible, but if you have a lot of data ( thousands+ of rows ) then a real database will be a lot faster.

Share this post


Link to post
Share on other sites

Yes I would prefer to use a database as well, but these resources are not available for use.

So far the data is broken down a column with each employee grouped by the departments that they work in. I need to track 4 separate metrics each day for a month. Then these totals for each metric is tallied and totaled for a month end sum of each metric. The main concern is how to keep the names of employees update across the sheets. I wasn?t sure if there was some Excel feature that would allow managing this easily.

1-24-20128-10-46AM.png

[/code]

Share this post


Link to post
Share on other sites

Oops, ninja edit :ninja: :p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.