VBA Macro is not running with existing formula

[rkb1510]

Hi Everyone,
I have created one macro which can insert date in Column B whenever Column A read "Ready" But it is working only when I Manually add "Ready" word in col A If Ready word come when condition of formula come true Col B is not populating date. I have set some formula in Col A which Populate ready whenever condition of formula become true. Can someone please help me with this issue?

 

[rkb1510]

Is there ANYTHING being manually entered in to the same row that is triggering these formulas to be updated (that ultimately lead to column M being updated).
If so, which columns are those?

You would just update the Worksheet_Change to watch for changes in those columns.
However, that would only work if the columns being manually updated are in the same row as the formula in column M being updated.

For example, let's say that columns A and B are being manually updated.
Let's say that manually updating column A doesn't affect anything, but manually updating column B ultimately leads to column M in the same row being updated.
If so, then we can program our Worksheet_Change event procedure to watch column B for updates, because those are the updates that ultimately lead to column M being updated.

unfortunately none of columns will be changing manually, except sometimes I am going to change col M manually but most of the time it will be changing with formulas.

But anyways thank you so much for your time and efforts. it was really helpful to diagnose and dig deep into problem.

 

[Joe4]

So, how exactly does the data change? Formulas call from other cells, which could call from other cells, etc.
If you trace it all the way back, what is the original change that causes all the formulas to update/change values?

Where is the source data coming from, and how/where is that being changed?