transferring data to another sheet

[yulo]

Hi,

how to create a macro for this:
1. say 10 columns table. i want to create several tables depending on the
number of entries in 1st column. please see below for illustration

entry1 data1 data2
blank data3 data4
blank data 5 data 6
entry 2 data 7 data8
entry 3 data 9 data 10

2. so i want to create 3 tables from the above data. table 1 will contain
entry 1 plus 6 data ( 3 columns, 3 rows), table 2 will contain entry 2 plus
data 7, 8 ( 1 row, 3 columns) table 3 will contain data 9 and 10 (1 row, 3
columns) ans so on.
3. the created tables' number of rows will be determined by the blank rows
in between entries in column 1.

please help.

thanks

 

[yulo]

Question
Hi,

how to create a macro for this:
1. say 10 columns table. i want to create several tables depending on the
number of entries in 1st column. please see below for illustration

entry1 data1 data2
blank data3 data4
blank data 5 data 6
entry 2 data 7 data8
entry 3 data 9 data 10

2. so i want to create 3 tables from the above data. table 1 will contain
entry 1 plus 6 data ( 3 columns, 3 rows), table 2 will contain entry 2 plus
data 7, 8 ( 1 row, 3 columns) table 3 will contain data 9 and 10 (1 row, 3
columns) ans so on.
3. the created tables' number of rows will be determined by the blank rows
in between entries in column 1.

please help.

thanks