HV_L
05-16-2019, 03:18 PM
Hi,
A few years ago I made a template to create an financial report from it.
But sometimes I want/have to adjust (add or remove) a couple of rows.
Then I have to be very carefull that I don't alter the rows beneath that point, or the formulas wont work anymore, because above the adding or removing, formulas pick up values from the lower part (which are shifted by adding rows)
Hope this makes sense..
Is there a way to still add some rows and not altering the cell name further down the sheet, which value is picked up, in the beginning of the sheet?
I.e:
Row 20 to 24 have values say
one
two
three
four
I want to add five and six which alters row 30 to 32. Now the cell on row 10 won't read cell 32 because it's set to read 30.
Pff I suck at explaining.. i know.. sorry:banghead:
A few years ago I made a template to create an financial report from it.
But sometimes I want/have to adjust (add or remove) a couple of rows.
Then I have to be very carefull that I don't alter the rows beneath that point, or the formulas wont work anymore, because above the adding or removing, formulas pick up values from the lower part (which are shifted by adding rows)
Hope this makes sense..
Is there a way to still add some rows and not altering the cell name further down the sheet, which value is picked up, in the beginning of the sheet?
I.e:
Row 20 to 24 have values say
one
two
three
four
I want to add five and six which alters row 30 to 32. Now the cell on row 10 won't read cell 32 because it's set to read 30.
Pff I suck at explaining.. i know.. sorry:banghead: