Using a Different Worksheet for Numbers and Not Copying Some Cells
Posted on 2013-12-13
In a workbook, I have Prices and CNP (plus more)
On CNP, I basically need the total of Prices Values: ($6.63)
(I did this on the same sheet).
And I need to copy this several times one sheet 2 (I am going to rename them - should I do this now).
But I also need to copy this. When I copy this, it is ($7.25):
if that is not possible, (how) can I copy cells but keep certain cells the same (on the same worksheet)?
For example, D/E16 (merged)
and D/E17 should
But if I copy it, I get:
Is there a way for Excel to copy some of the data?
I will have about ten work sheets in this workbook.
I could put everything on the same worksheet if necessary /easier, but I rather not.