Need help gettin this macro to run faster, Please!

[p45cal]

I'm really confused -- where did the 'All combinations of 5 from 35" come from?

The Col K data sample in post #1 just looked random

If that's the case, you could sort col g and just go down col K once

It came from message#53:

So the data in the K column is all possible combinations of numbers this is a set list and won't change,350,000 of them the data in column G are data of combinations that will match one of the ones in column K. Currently there are almost 8000 of these where one of combination will match the one in column K, eventually all will match as the list in column G gets bigger.

and from msg#55:

1to 35. The numbers I have in the column K I allready have in order from top to bottom, the numbers in column G are random as they become avail. The combinations themselves are in order from smallest to greatest left to right in the cell.

which was an answer to my query:

all combinations of 5 numbers picked from 1 to 36 (=376992 combinations)? Can they be in order, top to bottom of the list?