Hi have the attached solution which works. but it is too slow.

i was wondering if there is a way to modify the code and use alternative options in VBA for example Scripting Dictionary to make this solution work faster.

Book.xlsb