Rookie needs help!
 

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!


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=525428

Rookie needs help!
 

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

Rookie needs help!
 

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

Rookie needs help!
 

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

Rookie needs help!
 

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?


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=525428