I giant bill of ladings worksheet in excel that has a list of the item numbers and they are acending and it looks something like this :

0 0 0 0 2 9 1 0 0
0 0 0 0 2 9 1 0 1
0 0 0 0 2 9 1 0 2
0 0 0 0 2 9 1 0 3
0 0 0 0 2 9 1 0 4
0 0 0 0 2 9 1 0 5
0 0 0 0 2 9 1 0 6
0 0 0 0 2 9 1 0 7
0 0 0 0 2 9 1 0 8
0 0 0 0 2 9 1 0 9
0 0 0 0 2 9 1 1 0
0 0 0 0 2 9 1 1 1
0 0 0 0 2 9 1 1 2
0 0 0 0 2 9 1 1 3
0 0 0 0 2 9 1 1 4

I need this to fill an entire sheet of data upwards of 100+ rows.
My problem is that I feel like you can set a constraint on the Last two columns(to autofil) and have the last column acending by 0-9 and everytime that goes through that entire sequence then the 2nd to last column changes to the next 0-9. I was thinking a for loop in VBA, but I wasn't sure about the functionality of Excel in Autofil regaurds.

Any insight would help lots. Thanks!