From Ozgrid I picked up a formula that creates dynamic named ranges. Here is the formula I'm using for my needs:
My dynamic range begins at B15. There will be many times when a row will need to be inserted at row 15, however, when this happens the formula above changes to $B$16, then $B$17, and so on. I'm confused because I thought the formula was absolute based.
Is there a way to make it stay at B15, or make it step back every time a new row is inserted, or start at B14 (the heading) but exclude the heading from the results of the dynamic range?