Shane you are exactly right about the "delete formulas", I was just
now getting ready to send that if I change the data that's entered
into Col N by deleting and retyping, the formula is gone. The formula
does indeed stay if the formula enters the data. as for the 9 years, I
doubt it, by then somebody else can figure out a better way to do
things, and I'll be gone by then anyway....I'm just looking at the
short term here....I also have "Data range and formula formats"
checked under excel options but the formula does not extend down to
the next row.
Ken