Currently, formulas in MS Excel only let you call on cells that have constant
values. This has made it extremely difficult for me to manipulate
spreadsheets effectively in my company. I'm not sure if it is possible to
perform these tasks in Visual Basic Editor, but I strongly suggest that a
future version of Excel allow formulas to refer to other cells with formulas
and funtions (whose values could change). It doesn't seem too hard to
accomplish because whenever a formula refers to other cells with formulas,
following the line of cell references always ends with constants. In other
words, if you were to combine all formulas of this nature into one huge
formula, it would in fact refer only to constants.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.