1 I want to create a program to give me the data format as shown:
2 1,2,3,4,5,6, to 30
3 31,32,33, to 60
4 61, to 90
5 91,92, to 120
6 and so on
7 Can someone help me please?
8
9
10
11
to 300
Many Thanks!
1 I want to create a program to give me the data format as shown:
2 1,2,3,4,5,6, to 30
3 31,32,33, to 60
4 61, to 90
5 91,92, to 120
6 and so on
7 Can someone help me please?
8
9
10
11
to 300
Many Thanks!
1
2
3
4
5
6
7
8
9
10
11
to 300
I want to create a program to give me the data format as shown below:
1,2,3,4,5,6, to 30
31,32,33, to 60
61, to 90
91,92, to 120
and so on
Can someone help me please
enter this formula in A1. Copy it across to column AD and down to row 300.
=30*(ROW()-1)+COLUMN()
"tbobo" wrote:
>
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> 11
> to 300
>
> I want to create a program to give me the data format as shown below:
> 1,2,3,4,5,6, to 30
> 31,32,33, to 60
> 61, to 90
> 91,92, to 120
> and so on
> Can someone help me please
>
>
> --
> tbobo
> ------------------------------------------------------------------------
> tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
> View this thread: http://www.excelforum.com/showthread...hreadid=525428
>
>
This is the data all in column A1 to A300
1
2
3
4
5
6
7
8
9
10
11
to 300
I want to create a program to give me the data format as shown below:
for every 30 rows, it will put the data together with a "comma" between each number:
I like to see how it is written in VB:
1,2,3,4,5,6, to 30
31,32,33, to 60
61, to 90
91,92, to 120
and so on
Can someone help me please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks