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

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

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
 
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
 
Back
Top