I need help with a code that requires a loop. Basically I need help with copying the values from sheet 1 (1 row) to sheet 2 which will generate an output on sheet 3(same format as sheet 2). I would then need to copy the output from sheet 3 back to sheet 1. However the problem is that i would require to repeat this process for multiple rows on sheet 1. Would require some help with this.
Attached is an attachment for the example that i would require. Thanks in advance!
Sheet 1
Sheet 3 has formulas referenced to sheet 2. Basically the example stated on the first post is for 1 row of values. I would require a formula that copy pastes multiple rows of formula from sheet 1 to sheet 2 (Replacing cells previously pasted on to). This will generate a set of results on sheet 3 which i would need to copy back to sheet 1 on a new column but same row.