i dont know if this is possible but il give it a shot. i want to link a cell
with a letter value in it to a cell with a formula in it. so whenever a cell
with a specific letter value appears, in the cell ive linked it to, a
specific formula linked to that letter value will appear.
eg, D appears in one cell, the cell linked to it should display; =-A10
if H appears in the cell, the cell linked to it should display; =+A10
(or somthing like that)

at the moment im putting in the formula manually next to every cell where
the letter appears and it would save me a great deal of time if i could
figure this one out, any help would be appreciated

thanks
tom