ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding multiple tabs of same sheet, updateing summary (https://www.excelbanter.com/excel-programming/421193-adding-multiple-tabs-same-sheet-updateing-summary.html)

Andrew W

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



All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com