Good day All,
I want to input a set of 3 data inputs and extract the results from a formula. The formula itself is linked with many sheets and other formulas and is restricted to 1 row only for the input and result. From the 3 data inputs of a row, I will receive 2 results that will change automatically according to the input given. Here is the illustration to make it more comprehensible:
1. blank input for formula calculation. The raw data list is in orange, and the input cells are yellow. The extracted formula results should be listed in the green cells.
2. Input the 1st row, and we get 1st result
3. Extract the temporary 1st result and copy it to the green cells in the same rows as the raw data
4. Input 2nd row of raw data to get 2nd result
5. extract 2nd result to the green cells, same row as the 2nd input
6. Repeat till all rows are calculated
Is there a way for me to automate input and extracting a set of data into the desired cells without using autofill? I'm not familiar with VBA/other programming languages but I'm willing to learn.
Thank you in advance!
Warm regards,
Andre3
I want to input a set of 3 data inputs and extract the results from a formula. The formula itself is linked with many sheets and other formulas and is restricted to 1 row only for the input and result. From the 3 data inputs of a row, I will receive 2 results that will change automatically according to the input given. Here is the illustration to make it more comprehensible:
1. blank input for formula calculation. The raw data list is in orange, and the input cells are yellow. The extracted formula results should be listed in the green cells.
2. Input the 1st row, and we get 1st result
3. Extract the temporary 1st result and copy it to the green cells in the same rows as the raw data
4. Input 2nd row of raw data to get 2nd result
6. Repeat till all rows are calculated
Is there a way for me to automate input and extracting a set of data into the desired cells without using autofill? I'm not familiar with VBA/other programming languages but I'm willing to learn.
Thank you in advance!
Warm regards,
Andre3