increment a row reference with addition
Here is what I am trying to do:
1. select a range of cells, which may or may not be continuous
2. change the row number reference in each of the cell's formulas by
adding or subtracting to an integer to each reference to a row number
i.e. if one of the cells in the range had the formula
=H325+H320+H308+H303
I would like to be able to add or subtract an integer to it to get (in
the instance the integer was +2)
=H327+H322+H310+H305
This operation would need to repeat for each cell in the selected
range.
I read a few similar posts to try and get this to work, but didn't
have any success. A solution would be greatly appreciated !
Thanks,
Joshua
|