stefanfreund
New Member
- Joined
- Feb 23, 2017
- Messages
- 5
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.
<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
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