Excel: Excel Auto Complete Cells until given value

Hello friends, I have a question that is bothering me for some time now, and it is a bit difficult to explain, hope you will understand:confused:. I have a sheet that looks like the table below.

1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18
Now, I am trying to find out a way (formula, vba or some kind of solution) that I tell excel exactly till what number to go down the column, and then it continues to the other column. So for example in the table above there are 6 data inputs per column, but if for example my data set changes and I need to have 12 per column, then I would like that I just tell excel to automatically go like 1,2,3,4,5,6,7,8,9,10,11,12 and then continue with 13,14,15.. on the other column (yes, I want to have consecutive numbers from 1 until lets say 1000). I know it sounds a bit complicated or confusing so please let me know if something is not clear. Thank you very much in advance for your help! You are the best

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of February 23, 2017.

For more resources for Microsoft Excel