Forum Discussion
Re: insert specific date
Please find the attached Help file. I want if I enter date 20 OCT 2010 in cell J6 then automaticall insert row beteween 01 JULY 2009 and 01 July 2010 as it belongs to such period and in new cell between above dates , 20 oct 2010 inserted.
thanks
1 Reply
Well, the dates in column A are not generated by a formula, but have been entered manually. There is no relationship to cell J6. It looks like inserting a row and copying the formulas down might be the easiest approach.
The columns seem to have a mix of formulas and hard-coded values, though and it is not quite clear why formulas have been overwritten.
