The title says it all.
Can I "insert copied cells" and have them automatically follow a formula without having to update?
Everytime I insert copied cells the formula (=sum(a1:a5)) has to be updated to something like (=sum(a1:a7))
The reason I cant just do (=sum(A:A) is because I have multiple lists below aswell.
Thanks!
Bookmarks