Excel - Using Sheet2 equations to calculate multiple scenarios on Sheet1 -

i have setup sheet2 have 3 input fields (cells) , number of equations calculate result. there intermediate steps, lookup tables, etc..

let's input on sheet2 is

param1 goes in cell a1, param2-a2, param3-a3, result-a5 

now take sheet1 has rows of data sets need calculated same process.

row 1 have aparam1, aparam2, aparam3, aresult1 row 2 have bparam1, bparam2, bparam3, bresult1 ...... 

is there way have excel plugin param1,2,3 values sheet2, result , write sheet1? doing multiple rows, re-using sheet2 calculations.

i suppose can in vba, copying values on in sets , getting result, there non-vba approach?

there easy way re-use formula set based upon given parameters (that exist in different sheet) , return result. similar every time use built in function in excel's normal function list.

you can define custom function in vba wanting. here quick example of how custom function defined. has few parts: function definition, variables input, output data type , returning of data function excel sheet when called.

function calcit(base long, par1 long, par2 long, par3 long) long    ' {your math formula here based upon relationship base, par1,par2,par3}     calcit = '{replace output: returns math variable above formula}  ' section returns 'calc it' function excel sheet.  end function