How to Optimize This Code?

Good morning AlphaFrog, thank you for the reply

I saw your message yesterday and left the code running through the night. I can't really tell if it made it somehow faster, as it was still running in the morning when I woke up, but I found out something interesting. When I press ESC and end the code, the data seems to have been replaced properly, although the code was running as far as I could check everything was actually replaced, maybe something makes the code keep running for some reason.

I will upload a small sample as suggested by our friend above, that way you can see how the data is structured. All columns are located in the correct position according to the original file, but as the code works by selection, I only pasted the columns that are affected.


PS: Sheet3 has the column that's gonna be replaced, based on the 2 columns in the other sheet. I also didn't mention that the column with the data to be replaced has a text "Código" as a header, which is used later on for another code, and also the dates, both data that can't be deleted, but maybe could be causing the problem