Mar 28 2020 08:29 PM - edited Mar 29 2020 02:17 AM
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.
Mar 29 2020 01:08 AM
Solution@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.
Mar 29 2020 02:14 AM
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.
Mar 29 2020 02:14 AM
Thank you!
You confirmed my suggestion about the UserDefinedFunction to solve this problem.
Mar 29 2020 01:08 AM
Solution@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.