Hi All,

I have a points-based gradebook spreadsheet that tracks different daily
grades in addition to assignments and tests. For each day, there is a
column in which to insert points for an assignment and/or test. To the
left of this column are 3 columns:

Attend | Perform | Behave | Notes | Activity

(orange) (purple) (blue) (green)

(no. 0-5) (no. 0-5) (no. 0-5) (text) (any no.)

Ranges
(=Attndc) (=Prfmnc) (=Behvr) (=Notes) (=AssTest)

Could code be made that for every new day, insert these 5,
pre-formatted columns to the right of the last column in the
'Assignment or Test' range. Note that a test plus multiple assignments
could occur on one day, so there could be multiple columns in the
'Assignment or Test' range.

I plan to make formulas that add values in the different numeric
ranges. Thanks for any and all help.

Eric