4 variables to one sheet, then back to original sheet with answer
 

I recieve soil analysis reports back from a lab in a ASCII
format. I then paste them into a spread sheet for analysis
to calculate fertilizer and soil admendment
recommendations. Four of the variables that come back from
the lab need to be entered into another spreadsheet, (I
will call it a lime calculator) to calculate one of my
answers. The "lime calculator" goes through numerous steps
so it can not be consolidated it one formula. I thought of
putting an individual Lime calculator that would reference
to each individual sample, but there has got to be a
simplier way.
Thank you
Howard

4 variables to one sheet, then back to original sheet with answer
 

You may be interested in converting the lime calculation into a "user
defined function" (UDF).
A UDF is just a VBA function which you can use directly from the worksheet -
as if it were just another worksheet function.

The UDF would take 4 arguments and output one answer. The guts of the
function could be as many or as little steps as necessary.

Rob


"Howard" wrote in message
...
I recieve soil analysis reports back from a lab in a ASCII
format. I then paste them into a spread sheet for analysis
to calculate fertilizer and soil admendment
recommendations. Four of the variables that come back from
the lab need to be entered into another spreadsheet, (I
will call it a lime calculator) to calculate one of my
answers. The "lime calculator" goes through numerous steps
so it can not be consolidated it one formula. I thought of
putting an individual Lime calculator that would reference
to each individual sample, but there has got to be a
simplier way.
Thank you
Howard