user DaninSA said:
How do I set a cell to change it's formula based on data in the row?
My question may not be phrased correctly, so let me explain what I'm trying to do. I am maintaining a spreadsheet for a group of friends involved in a weight loss program. It is set up with columns for initial weigh in, then weekly weigh ins. I have formulas based on the last entered weigh in data, but I have to manually edit those formulas as the users enter the data.