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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]9
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]10
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]11
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]12
[/TD]
[TD]18
[/TD]
[/TR]
</tbody>[/TABLE]

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.