Hii..

I'm looking for a macro or condition statement which would do following for me:

If cell A1 is "BUY" then run a macro automatically which will add current value in cell B1 to cell A3
so everything theres a "BUY" in cell A1..macro will keep addiing B1 values in cell A3

and

If cell A1 is "SELL" then run a macro automatically which will add current value in cell B1 to cell A4
so everything theres a "SELL" in cell A1..macro will keep addiing B1 values in cell A4

Hope it makes sense...also A1 will be updated dynamically through external source i