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

Do you want a userform? Where a box pops up and there will be boxes on
the form tied into cells on your spreadsheet?


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

I'm honestly not sure.

If you think something like that would work best, than I can't argue.
You have infinately more Excel knowledge than I.


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

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