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.