Hi, i have a problem which i am sure you can help me with.. i have
written a spreadsheet which decides which horses to bet on in a race.
one minute before the race a set of data is imported into the sheet and
one two or more horses are picked. then one minute before the next
race usually ten minutes later a new set of data is imported and the
process begins again deleting all the info from the last race and
replacing it with the new . now what i want to be able to do is store
the name of the horse which appears in say cell a1 or a2 or a3 from the
first race in order to use it to establish the stake for the next race.

in other words i want to be able to save the data from a cell that is
constantly changing and maybe put it into a list which i can then use
to change other cells. and all this has top be performed without
interaction from me, any suggestions? thanks in advance


--
mrclox
------------------------------------------------------------------------
mrclox's Profile: http://www.excelforum.com/member.php...o&userid=29011
View this thread: http://www.excelforum.com/showthread...hreadid=487425