So I have a formula in Cell F17:
=(E6*F6+E7*F7+E8*F8)/F15
If I insert a row say at E6 now my formula reads:
=(E7*F7+E8*F8+E9*F9)/F16
I want to include the new row in the formula so it reads:
=(E6*F6+E7*F7+E8*F8+E9*F9)/F16
Can I do this somehow with the formula or is this a VBA issue?
Bookmarks