Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
Transferring Data from one sheet to another | Excel Discussion (Misc queries) | |||
Transferring data from one sheet to another if criteria are met. | Excel Worksheet Functions | |||
Transferring data from one sheet to another | Excel Programming |