Let me clarify. Are you saying that in the first sheet "2013 PL", row 6 will be increased by 10% and this will be entered into row 6 on the second sheet "2014 PL"?
Here is what I have done so far:http://wikisend.com/download/268608/2012-2014 Copy P&L_rev1.xlsx
The way to do it here is to click on cell C6 in the second sheet then press the = sign to start a formula. Since you will be referencing the data in the other sheet, click on the first sheet named 2013 PL and the name of the sheet will be entered into the formula. Now, select the cell you want to reference, and that is cell C6 also in the first sheet, then multiply it by 0.1 then add it to itself. Thus the formula created is:
='2013 P&L'!C6*0.1+'2013 P&L'!C6
Now, with the right formula in place, you can drag the "fill handle" to the right to copy the formula all the way to the December column.
The fill handle is the lower right corner of the cell, the mouse pointer turns to + when you posistion it to the fill handle.
Now, if the formula is the same below row 6, you can drag the fill handle down to copy it downwards. But if the formula is different, you cannot do that.
The perfect example is the conference operations block, since the increase is uniform at 10%. This is how it is done:
In the second sheet begin a formula by pressing = in cell C26. Then click the first sheet then select the equivalent cell C20. Multiply it by 0.1 then add it to itself (type + then click on the cell again and the formula will be entered automatically). When the first cell's formula is done in cell C26, click and drag the FILL HANDLE all the way down to C64. The formula will be copied automatically.
While C26 to C64 is selected, click and drag the fill handle again all the way to column N. Everything will be copied.
These are my screen shots:
Here is the completed file:http://wikisend.com/download/577416/2012-2014 Copy P&L_rev2.xlsx
Please remember to rate my service positively (3-5 stars/faces)
once you have all the information you need. Tips
are always highly appreciated!
If you have any other questions, please ask me more or reply to me
– I’ll be happy to respond.