software

1I want to create a program to give me the data format as shown:
21,2,3,4,5,6, to 30
331,32,33, to 60
461, to 90
591,92, to 120
6and so on
7Can someone help me please?
8
9
10
11
to 300

Many Thanks!--
tbobo
------------------------------------------------------------------------
tbobo's Profile: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=525428
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: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=525428
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: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=525428enter this formula in A1. Copy it across to column AD and down to row 300.

=30*(ROW()-1) COLUMN()

quot;tboboquot; wrote:

gt;
gt; 1
gt; 2
gt; 3
gt; 4
gt; 5
gt; 6
gt; 7
gt; 8
gt; 9
gt; 10
gt; 11
gt; to 300
gt;
gt; I want to create a program to give me the data format as shown below:
gt; 1,2,3,4,5,6, to 30
gt; 31,32,33, to 60
gt; 61, to 90
gt; 91,92, to 120
gt; and so on
gt; Can someone help me please
gt;
gt;
gt; --
gt; tbobo
gt; ------------------------------------------------------------------------
gt; tbobo's Profile: www.excelforum.com/member.php...oamp;userid=31530
gt; View this thread: www.excelforum.com/showthread...hreadid=525428
gt;
gt;


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 quot;commaquot; 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?--
tbobo
------------------------------------------------------------------------
tbobo's Profile: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=525428