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