Okay all that makes sense but still not quite what I'm looking for. I guess it's harder to explain than I thought. I'll give it another shot.
What I want, and I don't think is possible, is to be able to put an equation in cell A1. I would want this equation to look like the following: =5*A1 (just an example equation). Then lock the cell or equation to that cell somehow so it can't be deleted. Next in the same cell, A1, you would input any number, lets say 4 so the answer would then say 20 in cell A1. When you input this equation into cell A1 you get a "Circular Reference Warning" which makes sense. But it would be nice if I could put an equation in the cell and lock it and be able to input a number within the same cell and have it formulate without the use of other cells.
Now wouldn't that rock! Hopefully you get the vision now. Thanks for you suggestions gebobs.
|