I wonder have you managed to resolve this?
http://www.excelforum.com/excel-misc...sheet-2-a.html
I have similar problem. A complex calculation on one sheet it has one input and one output. I would like to use it as formula to calculate the same for an array of inputs.
To put it simple is there any way to use complex calculation on one sheet as "formula" for others. Simple input-output process?
Last edited by VBA Noob; 12-24-2008 at 04:10 PM.
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
I've not succeeded in finding a simple solution to this. This can be accomplished with VBA, either defining UDF or (in combination) with manipulating sheet content. Altough avoiding VBA would be the best solution, but I have not yet found such a solution.
It surprises me a bit that this obviously "common" problem does not have a simple solution - but I might have searched in the wrong places. I'll post any solution in my own thread.
Regards
Jan-Roger
Igi, no one understood what janroger was trying to do in the last thread, no one knows what you're trying to do at all. If you can explain it clearly, someone would be happy to help.
The answer may be a Data Table, which tabulates results of a common set of calculations applied to different sets of parameters, but understanding the question is where we need to start.
Last edited by shg; 12-26-2008 at 06:13 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks