Excel Auto Complete Cells until given value

[stefanfreund]

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.

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

<tbody>
</tbody>

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

 

[stefanfreund]

Will definitely do! Thanks again

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

 

[MickG]

Hi Ingolf
That todays deliberate mistake, well spotted !!!
I originally has a code "If c mod numPc = 0 then ---" but I changed it, but forgot to alter everything else.

I actually should have replaced "13" by NumPC.
My only excuse is , It extremely windy here !!, I already had an Electricity failure this morning , and Am just waiting for the Conservatory roof to disappear !!!!

 

[Ingolf]

Thank you MickG.