Remember Me?
Menu
Home
Search
Today's Posts
Home
Search
Today's Posts
ExcelBanter
»
Excel Newsgroups
»
Excel Discussion (Misc queries)
>
Define inputs and outputs to make functions from sheets
LinkBack
Thread Tools
Search this Thread
Display Modes
Prev
Next
#
2
Norman Jones
Posts: n/a
Hi Prophet,
Perhaps you should address this to Microsoft.
You could send an email to:
Alternatively, visit their product suggestions page at:
http://tinyurl.com/22y7
For your information, this is a peer-to-peer newsgroup.
---
Regards,
Norman
"Prophet of Nixon" <Prophet of
wrote in
message ...
Suggestion:
Add a feature to Excel which allows a sheet to be defined as a function in
another sheet, with names input cells, and named output cells. For
instance,
if I had a complex sheet named "estimator" which determined an inflated
future cost of a room using inputs "seats" and "technology_level" and
produced the result "future cost", let me call it from another sheet by
setting a cell = "estimator(seats=50, technology_level=3, return
future_cost)" or something of the sort. This would be a wonderful feature
since it would allow more or less ad-hoc creation of powerful functions,
without needing vba.
Another feature which would be nice would be the ability to define cells
or
merged cells as embedded controls (as in the control toolbox). The
embedded
control would be in the cell, and would have its position and dimensions
determined by the cell. The control toolbox controls are great, but NEVER
print in the right places, and don't keep their positional relationship
with
the rest of a sheet well.
That's it...
Reply With Quote
Thread Tools
Search this Thread
Show Printable Version
Search this Thread
:
Advanced Search
Display Modes
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Posting Rules
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
All times are GMT +1. The time now is
02:28 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
Contact Us
ExcelBanter forum home
Privacy Statement
LinkBack
LinkBack URL
About LinkBacks