I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indication a symbol or not. Each symbol if selected indicates progress on a project in a separate cell (A), i.e. Reported, Initiated, In Progress, etc. Unfortunately I have to remove the symbol (i.e, Cell B) each time the status of the project changes and then select the symbol in another cell (i.e, C) to display the current status. I need to have the project status displayed in the cell A by selecting the updated symbol in cells B-F without removing the previous symbol, in other words the next symbol selection should take preference over the previous one.
Perhaps you need to build another colum for a lookup, from most important to least. Then the lookup, will match on the first one, which will be the one up the chain higher than the previous. I think you are running into a code firing problem. Just have it do what it is currently doing on a worksheet change method. Try that first.