ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2009 Template for Attendance: How do I add multiple tabs of employ (https://www.excelbanter.com/excel-worksheet-functions/217503-2009-template-attendance-how-do-i-add-multiple-tabs-employ.html)

Ashleysquared

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

Ron@Buy

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



All times are GMT +1. The time now is 05:46 AM.

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