i'm stumped on this and i'll try to explain what i'm trying to achieve, but have uploaded a simplified version as well if my explanation is poor.
I capture external data in to Range A1:A50 of numbers , this data changes every minute or so, but sometimes a lot quicker
In Range B1:B50 is a formula crunching numbers in Range A1:A50.
In range C1:C50 is a formula to get a match result if reaching a criteria e.g If B6 value is >5 and < 10 "match"
The problem is as the values in column A6 changes the word "match" comes and goes in column C6
So in column D6 i want to paste the value "match" if it appears in column B so it stays in place in D6 whether it stays in C6 or not.
I gather it will be a trigger event in worksheet code rather than a macro, but from here i'm stuck.
Appreciate any help
Thanks in advance