I was not sur if there was a way to have a formula move cells as you type. I
am not explaining it right, but say I have a spreadsheet for weight loss for
a group of people if the begginging weight is in cell A1 and the next week's
weight is in B1 and week after that is in C1 can I have the subtraction
"follow" the numbers to show weight lost each week? :

A1 B1 Formula
196 194 2

next week would be

A1 B1 C1 Formula
196 194 190 4

So that when I typed in C1 the formula shifted so as to ignor A1 and
subtract C1 from B1. Is this possible? thanks!