I know you have the answer Woof43.
And I appreciate you trying to help.
But as usual , you really may as well be talking in Chinese.
I can't even understand NoRisk, and at that stage I don't think he even cracked his first tinny.

The New data gets pasted into Column G NoRisk.

Then the Norisk Columns contents get pasted over the top of Columns B to F and then Column G is cleared.

And then we do it all again in 24 hours or so