J
julia
In one cell, I reference a cell in the next column to the left and one
row down
e.g., in cell Y182, I have:
if (Z183 = "No content liens","n","y")
But I often insert rows between rows 182 and 183. When I add a row,
the original contents of row 183 move down to row 184, but the formula
in cell Y182 also now references row 184.
I want the cell reference in Y182 to still refer to the immediately
adjacent row even after a new row is added (effectively I want that
reference to change to the "new" row - not the originally referenced
row).
Is that possible?
Julia Bell
row down
e.g., in cell Y182, I have:
if (Z183 = "No content liens","n","y")
But I often insert rows between rows 182 and 183. When I add a row,
the original contents of row 183 move down to row 184, but the formula
in cell Y182 also now references row 184.
I want the cell reference in Y182 to still refer to the immediately
adjacent row even after a new row is added (effectively I want that
reference to change to the "new" row - not the originally referenced
row).
Is that possible?
Julia Bell