Hey all, I am in a middle of sorting through data for a project and it is becoming very tedious (there is an enormous amount of data). I would appreciate any help in coding a VBA macro to automate the process below:

To simplify, I have two columns of data that have number sets that are repeating (for example, I will denote these two columns as 'A' and 'B'):

A B
1 1
1 2
1 3
1 4
1 5
1 6
1 7

* Column A will repeat a constant from 1 to 9, so for the next iteration, column A will repeat the number two 7 times, and the iteration after will repeat three 7 times and etc...

* Column B will always range from 1 to 7

* This pattern will repeat 7000 rows!

The problem is that in the set of data that I have, some rows are missing. For example, for some repeat of the sets will look like below:

A B
2 1
2 2
2 3
2 4
2 6
2 7

*Notice that the above set is missing the one row: 2,5

I would appreciate some help in developing a macro that will run through the data, find the missing points and insert the proper numbers so that every repeat of the sets will have a column A that is repeating a certain constant (again, the constant ranges from 1 to 9) and a column B that will range consistently from 1-7.

Thanks in advance!