Adding multiple tabs of same sheet, updateing summary

A

Andrew W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top