These names should be automatically propogated to all other worksheets. New employees should be added to the "Employee Names" worksheet. The same needs to be done for each of the monthly worksheets. I have done this for "Dash-new" and August and September. Make sure that the employee names are the same on all worksheets and are driven from the "Employee Names" worksheet.Reorder the monthly worksheets so they go April thru March.Populate with the same headers as the "Dashboard" worksheet. Create a new dashboard worksheet called "Dash-New".Here's what I did to get you started if you want to follow this particular approach (no macros needed I don't think): Don't delete the column entirely as with the below approach all monthly worksheets need to be laid out identically. With regard to Pete's comment, my instinct was to delete the superfluous 31's but because they are table headers Excel seems to be "helpfully" refusing to let you clear the cell. Is that external workbook now redundant? I assume you want to create a similar summary dashboard from the worksheets within THIS workbook right? What is going on with the "Dashboard" worksheet? Col-H (holiday days taken) and col-I (Total sick days) are referencing some other workbook via horrendous formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |