PC Review


Reply
Thread Tools Rate Thread

Adding multiple tabs of same sheet, updateing summary

 
 
Andrew W
Guest
Posts: n/a
 
      11th Dec 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate % in summary sheet from cell A9 in multiple sheet wissam Microsoft Excel Programming 3 25th Jan 2010 03:01 AM
Display a summary sheet, for several tabs Duncs Microsoft Excel Discussion 16 3rd Nov 2008 09:45 PM
If Then or other to roll up multiple tabs to one summary tab - hel =?Utf-8?B?U3RldmU=?= Microsoft Excel Misc 3 7th Sep 2007 07:52 PM
reference tabs in a summary sheet as column headers =?Utf-8?B?SkRS?= Microsoft Excel Misc 6 7th Mar 2007 06:04 PM
Summary sheet for 80+ tabs/worksheets =?Utf-8?B?Q29yZXk=?= Microsoft Excel Misc 2 18th Nov 2005 05:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:50 AM.