Need Help With adding two more columns

[rtohagan]

Good evening all and thanks for letting me register! I've attached an assessment tracker that was made by a former colleague that I no longer have contact info for. I've used this assessment tracker for a while (I'm a teacher) and it works really well, but this year I have a few additional assessments than normal due to online learning. I need help adding in two more assessments and having that translate to the rest of the book.

Is there an easy way to do this or is it incredibly tedious?

Thanks!
Ryan

[mikeava]

Please check this over and let me know if everything is ok.

I inserted two columns on cover sheet and copied formula over into the new columns.
I then added two rows onto each sheet and copied formulas down. FYI - if you are on tab 1 and hit Shift then select Tab 20 (for example) anything you do on one tab will update rest automatically. then hit Shift again and deselct.

[rtohagan]

Please check this over and let me know if everything is ok.

I inserted two columns on cover sheet and copied formula over into the new columns.
I then added two rows onto each sheet and copied formulas down. FYI - if you are on tab 1 and hit Shift then select Tab 20 (for example) anything you do on one tab will update rest automatically. then hit Shift again and deselct.

Thanks so much, Mikeava! It's close but when I add an assessment to the second last column, it auto populates to all 4 of the rows noted in Student 1 and doesn't populate at all for any other students. Thoughts?

[mikeava]

Formulas were suppose to copy down and autofill but looks like they didn't.

[mikeava]

Sorry about that --- let me know how this one is.

[rtohagan]

Everything is working great. Thank you SO much!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.