I can copy and paste the original, yes. And yes, the dotted line still shows
around the box I just copied whether I move to another sheet or not. What
does that mean?

"bj" wrote:

can you copy and paste in the original sheet?
The sheet may be protected which keeps you from copying.
also there might be a macro which effectivley loses the copy information
when you change cells or work sheets
When you click off the cell you have just copied, do you still show the
dotted line around the cell.
if so, when you click on another sheet and back again, does it still show
the dotted line around the copied cell?

"tcreller" wrote:

Our workbook is used to track bonus hours for employees. Each week has a
different worksheet. What I want to know is if there is a formula that I can
put in the carryover cell (ex. H1 on Sheet 1) that will automatically put
that same number on the next sheet (ex. C1 on Sheet 2). I looked in the help
section of excel and it says to copy and paste and then click paste special
for linking cells, but for some reason when I copy and paste, the number
won't show up after I paste it and there is no paste special or link cells
option.