Forum Discussion
[SOLVED]Using another sheet like function
Hi!
It is general question about Excel. No certain examples i can attach.
I have 2 sheets. "Sheet 1" contains input data columns and result column. "Sheet 2" calculates result using many operations with input data. Is there any way to put data row by row from sheet 1 to sheet 2 and return results to sheet 1? See pic for more information.
Thanks.
P.S. Add example of what i am talking about.
Phobosd What you describe is achieved by User Defined Functions (requires VBA programming) or by what is often referred to as "helper" columns, where each column contains a formula that solves part of the problem. The attached workbook contains a very simple example of both. You only need to imagine that the three calculations in this example are in fact the "hard calculations too complicated to be described with one formula" that you mentioned.
4 Replies
As variant you may perform calculations column by column for each row in source sheet. Thus each row in calculation sheet will be mapped on each row in source sheet.
- Thanks! I'll think about it more...
Phobosd What you describe is achieved by User Defined Functions (requires VBA programming) or by what is often referred to as "helper" columns, where each column contains a formula that solves part of the problem. The attached workbook contains a very simple example of both. You only need to imagine that the three calculations in this example are in fact the "hard calculations too complicated to be described with one formula" that you mentioned.
Thank you!
You confirmed my suggestion about the UserDefinedFunction to solve this problem.
