Is there any way of tracking the range editing of a concatenate formula. Suppose I have concatenate formula in cell A1 like this, =concatenate(B12,H12,S12)
Keeping in view above basic formula, if I press F2, and drag range of B12 to B20, would it be possible to link it with column H and column S also.(Note that I usually use those color coded dragable ranges instead of editing formula in formula bar )
The above example is very basic dealing with only 3 columns or ranges, but in my case I have about 6 columns and further concatenated with some separators like " / " or " --- " and every time I have to edit this formula, it takes a bit of extra time.
I was hoping to get a clue of some kind of available event within Excel which triggers as soon as range for column B in my concatenate formula in cell A1 changes and identifies that the range in concatenate formula for column B has changed from row 12 to row 20.