Excel - Copy/paste cell with a formula
Posted on 2016-07-22
Hi everyone. Happy Friday. :)
I maintain a timesheet for my work that contains daily totals. e.g. for 7/21/16, I might have worked on three things. The time for each project is in column C e.g.
Cell D100: 1:00
Cell D101: 0:30
Cell D102: 3:30
Cell D103: =SUM(D100:D102) = 5:00
A second sheet contains a weekly calendar. I want to copy/paste (e.g) the 5:00 value in D103 (first sheet) into (e.g.) cell E22 (second sheet) which represents 7/21/16; however, Excel thinks I want to paste the formula (not the value).
I looked at paste special; however, it did not contain any options that seemed helpful.
Is there a workaround? (I'd rather avoid referencing the first sheet in the second sheet,)