Hi all,
I got a spreadsheet that takes readings from a controller and copies the
info to a cell in the spreadsheet. These readings are done at a certian time
and date. On the spreadsheet now, there is a conditional formula (If
formula) that is constently updating the value in that cell. What I would
like to do is automate the process so that the data is recorded in that cell
for the conditions that match (The certian time and date) then moves to the
next cell below and does the same for when the condition is meet. I have
wrote a udf that does some of this, but have been unable to run the function
from the conditional formula (If formula) on the spreadsheet. A example is
below:

Time Helium Trailer Pressure
11:00 2484.0 44.6
7:00 2292.0 30.5
7:00 2168.0 27.4
7:00 1983.0 35.0 =IF($K$1=$L11, metalink|read.bgtc!trailer\hetemp,"")
in the cell (35.0 value) the above if is contained where K1 is a value for
a day and L11 is the matching value for the row where the data is collected).
where the "metalink" statement is, that is where I would like to call a
function that will write the value and the value be the data collected at
that time, not constently changing.

Thanks for any help in advance

Jerry