Solved
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)
=SUM((A16*D3)+(A16*E3))
(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):
=SUM((A17*D4)+(A17*E4))
-or-
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)
=SUM((A16*D2)+(B16*E3))
and D/E17 should
=SUM((A17*D3)+(B17*E3)
But if I copy it, I get:
=SUM((A17*D4)+(B17*E4))
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.
Thank you