Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the original setup for an inventory sheet | Setting up and Configuration of Excel | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
???Replicate a sheet but chart still link to original sheet | Charts and Charting in Excel | |||
Preserve original workbook, but add new sheet? | Excel Programming | |||
Running sheet from another sheet ... and back | Excel Programming |