Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 2009 Template for Attendance: How do I add multiple tabs of employ

I was able to get the original dowload of this template to work properly but
when I copy and pasted multiples so that each employee has his own tab in the
file for tracking, it doesnt work when I enter the Vacation etc. in. Can you
help?
Here is the template:
http://office.microsoft.com/en-us/te...CT101436151033

Any help would be greatly appreciated.
--
Ashley
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 345
Default 2009 Template for Attendance: How do I add multiple tabs of employ

The reason is that each month has been range named, when you copy to a new
worksheet the range name still refers back to the original worksheet you can
see this by going to Formulas Name Manager. I guess you can change each
individually, there must be a way to globally change this but I am unsure how
at this stage. I anticipate that others reading this will have the solution.

"Ashleysquared" wrote:

I was able to get the original dowload of this template to work properly but
when I copy and pasted multiples so that each employee has his own tab in the
file for tracking, it doesnt work when I enter the Vacation etc. in. Can you
help?
Here is the template:
http://office.microsoft.com/en-us/te...CT101436151033

Any help would be greatly appreciated.
--
Ashley

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
2009 employee attendance tracker George Excel Discussion (Misc queries) 8 January 7th 09 08:40 PM
How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 callmark1 Excel Discussion (Misc queries) 1 December 28th 08 09:14 AM
How can I update the Employee Absence Schedule template to 2009? mellor Setting up and Configuration of Excel 1 November 7th 08 12:52 AM
Student Attendance Record Template Nita Excel Discussion (Misc queries) 6 June 9th 06 02:08 PM
FIX ATTENDANCE CALENDAR TEMPLATE - INCORRECT DATE Incorrect Template Name Excel Discussion (Misc queries) 0 July 22nd 05 03:47 AM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"