Hi
I have this piece of code below, when u run the macro, the yellow highlighted code is copying the formula from the other worksheet. I want it to copy only the values not the formula.
What modifications should i make to the code to get just the values copied over

Capture.PNG

Thanks