Create Table with quartils

[vangog]

I am getting in trouble with for loop combined with match.
Can you help please? Macro is too slow.
You can download the file from here:
https://www.uschovna.cz/download/TO7...KJ/RDZ4DS4RF5/
when you will download the file let me know to delete that immediately.

My problem is in module Step2_rename_hospitals... In the first For loop. I think the problem could be on the line:

m = Application.Match(OriginalTable.Cells(i, NemocniceCol).Value, Nemocnice.Columns(2), 0)

Honestly, I am not sure what exactly is this line doing. Is the search limited per line number i? Or does this continue to seek on the next rows? If the match is performed only on the line i, then how to boost this step?

You will run this macro if you click on first button and then on newly created button.

This macro replaces strings of hospitals ("Nemocnice") and districts ("Kraje") by reference to Nemocnice sheet.