I'm not sure I follow everything you are trying to explain.
A sample book with the data you have and what you are trying to accomplish is helpful.
Do you want the value in A1 or B1 to change the same amount that C1 was before it was deleted?
are the values in A1 B1 or C1 calculated by formulas?
Bookmarks