Hi community, hopefully somebody can help me out with this super simple problem I have.

I have inputted a basic button (well in actual fact there will be about 18 of these in total) that individually make an order based on numbers on another sheet. These 18 buttons are on a tab named 'Dashboard', they are to reference cells in the tab 'Bet Angel'.

Basically I'd like my first button to write the word "BACK" in cell L9 but then (this is the part I'm having trouble with) WAIT until cell O9 shows "PLACED" and then wipe both cells ready to be placed again. I have 6 "BACK" buttons, 6 "LAY" and 6 "CLOSE_TRADE" that affect the cells L9:19 and O9:O19 if the code someone comes up with works best as 3 separate rules instead of 18 in total.

Looking forward to your replies!
CPerry