Hi
I have created a dropdown box via data validation which works well
I am trying to work out if ther is away of linking a value to this that be will alter a cell
eg A column contains the value of “potential”orders which I mark as pending. However if the deal doesn’t come off I mark it as “unsuccessful”
what i wish to do is link this as a zero value to the cell on that row that is in the value column which thus will take it off the sum total of that column
ie cell “M23” has value of£100 when marked as “potential” but makes it zero when marked as “unsuccessful’
feel I should not how to do this!
I have created a dropdown box via data validation which works well
I am trying to work out if ther is away of linking a value to this that be will alter a cell
eg A column contains the value of “potential”orders which I mark as pending. However if the deal doesn’t come off I mark it as “unsuccessful”
what i wish to do is link this as a zero value to the cell on that row that is in the value column which thus will take it off the sum total of that column
ie cell “M23” has value of£100 when marked as “potential” but makes it zero when marked as “unsuccessful’
feel I should not how to do this!