I don't know much about what you have, but it sounds like you could use a
cell reference or cell name in your formulas. Then when you change the
contents of that one cell, the change will be carried throughout your sheet.
This is commonly done. Does this help? Otto
"seanryann" wrote in
message ...

I have a fairly complicated spreadsheet, with basic formulas, but many
cells that inter-relate with each other.

I am looking for a way in which I can simply create an option so that
you type in a number into a cell off to the side of the main part of
the sheet(which would change, say, revenue), and it will show how it
affects another cell (say, return on investment).

I want to make the spreadsheet more user-friendly, so that outside
users don't have to go into the main part of the sheet and enter
specific numbers to see how it affects other cells.

Does that make any sense? Is there a way to do such a thing?

Thanks for your help.


--
seanryann
------------------------------------------------------------------------
seanryann's Profile:
http://www.excelforum.com/member.php...o&userid=32599
View this thread: http://www.excelforum.com/showthread...hreadid=524007