Deleting Cells That Are Linked

[KlayColgrove]

I have made two buttons that will add and delete the last column of data, but when I delete the column other cells that have formulas linked to the last column of data are also deleted. Is there a way to make it so that the formula is still locked to those cells after the column has been deleted?

 

[bobsan42]

opt 1. Clear the contents instead of deleting the column
opt 2. use indirect references (e.g. INDIRECT, INDEX)
opt 3. use named ranges, after deleting the column assign the same name to the new column (THIS IS NOT TESTED - JUST AN IDEA)