vba excel combination and search for matches

[Eager_For_Knowledge]

I need help in creating an excel VBA that will do the following:1.Sheet1 generate the combinations of 6 numbers, each number range from 1 - 39. The numbers generated should be placed in ColumnA down to row 1048576 and if the combination is not finished continue to ColumnB down and repeat the process to ColumnC onwards until all the combinations are all listed. The numbers in the combination should be delimited by a space like 23 5 1 12 9 10
2.Then if sheet2 ColumnA isNot empty search sheet1 against sheet2 ColumnA to see if any sequence matches in sheet1. if match then highlight cell in sheet1.
Note: Sheet2 will have a set of numbers manually inputted by user in each row in ColumnA. These numbers will also be delimited by a space like 23 5 1 12 9 10
Expert help needed