Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding multiple tabs of same sheet, updateing summary
I am using a great Excel template posted on the MS Website. The first tab
(meant for a single employee) is a calendar for 2009 and you can code what kind of absences that employee has thorughout the year. The worksheet totals at the bottom and it also links to another Summary tab. The problem is that There is only one employee tab in the template. Is there a way to add a tab for each employee and efficiently update the Summary tab? of do I have to hardkey a tab and cell number in each cell in the summary page? I am using a Excel 2009 spreadsheet converted to my 2003 Excel. The template on the microsoft site is called "2009 Employee Attendance Tracker" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then or other to roll up multiple tabs to one summary tab - hel | Excel Discussion (Misc queries) | |||
reference tabs in a summary sheet as column headers | Excel Discussion (Misc queries) | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Programming | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
Summary sheet for 80+ tabs/worksheets | Excel Discussion (Misc queries) |