Update References in Formulas when Columns are Inserted and Rows are Skipped
Thanks Bob, I didn't mention that there are other columns that start
after the last assignment column. The other columns, which are for
daily attendence and participation points and progress notes currently
start in column AI (leaving one blank column between the last
assignment column and the first date column). I suppose I could do as
you suggested and insert blank columns to be used for assignments.
However, manual manipulation would still have to be done--extra blank
columns would have to be removed later, or additional ones added if
needed.
|