I need a piece of code which execute my module "Copy Trigger Data" on formula out put to text string in Range L2:L1699. Formula given in such a way that if condition is true then it will returns to text string else "".
before execute I require it passes through 2 condition.
For example say cell L3 returns to "Test" via formula.
Need to check
If time is not between 9:40 - 15:30 & M3="" then put M3="Zzz" & Exit
if time is between 9:40 - 15:30 & M3<>"Posted" then put M3="Posted" & execute "Sub Copy Trigger Data" Module.
Definitely I need separate module for above procedures & I don't want any human intervention. above procedure run as and when range L2:L1699 changes to Text string from "" i.e. automatic.