Inputting raw data from rows and extracting results from temporary formula result into respective rows

Andre3

New Member
Joined
Dec 13, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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:

1670991116806.png

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.

1670991188707.png

2. Input the 1st row, and we get 1st result

1670991228794.png

3. Extract the temporary 1st result and copy it to the green cells in the same rows as the raw data

1670991275167.png

4. Input 2nd row of raw data to get 2nd result

1670991408179.png
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,884
Messages
6,175,175
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top