did you try copy=pastespescial-values (not testex)

"JAG" wrote in message
...
I am trying to create a employee time tracking sheet, I can auto populate
the
time and date no problem for each record i.e. login, logout however once I
perform that task I need that data to write to a different cell on a
different worksheet based on the date criteria and remain there when the
date
changes. Any suggestions?