I have come up with a code using three scripting dictionaries. It draws from data in a worksheet that currently contains upwards of 12,000 rows.
It also inserts a formula (value of result) in a column for each row of this data.
Currently, when I run it excel almost crashes. Eventually it gets there, so it works, but it takes quite a while to work.
I could run each element of the code in separate Subs, but this is far from ideal as a solution.
So I am looking for a way to speed up the current code if possible.
here is the code:
Bookmarks