Hi Friends,
I have a huge spreadsheet (~20.000 rows each time). It looks like as follows:
I need to group by column E and split these records into seperate workbooks. In this example i want to get two workbooks with the names:
11-XXX-12.xls
11-XXX-13.xls
and containing only the records which belongs to column E.
Anybody idea how to setup this?
A star for the golden solution!
I have a huge spreadsheet (~20.000 rows each time). It looks like as follows:
Code:
Column A B C D E F G H I J
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 05:56:17 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 08:29:27 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 10:33:55 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 11:51:54 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 12:49:45 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 13:53:35 3,14
Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 14:57:59 3,14
Test records 595 595 A 11-XXX-12 3522 A 5-11-2013 05:24:56 3,14
Test records 595 595 A 11-XXX-12 3522 A 5-11-2013 07:44:06 3,14
Test records 595 595 A 11-XXX-12 3522 A 5-11-2013 08:37:08 3,14
Test records 595 595 A 11-XXX-12 3522 A 5-11-2013 10:00:48 3,14
Test records 595 595 A 11-XXX-12 3522 A 5-11-2013 11:59:54 3,14
Test records 595 595 A 11-XXX-12 3522 A 6-11-2013 05:40:48 3,14
Test recordss 595 595 A 11-XXX-13 3523 A 6-11-2013 08:39:37 3,14
Test recordss 595 595 A 11-XXX-13 3523 A 6-11-2013 10:06:36 3,14
Test recordss 595 595 A 11-XXX-13 3523 A 7-11-2013 05:25:56 3,14
Test recordss 595 595 A 11-XXX-13 3523 A 7-11-2013 07:47:20 3,14
I need to group by column E and split these records into seperate workbooks. In this example i want to get two workbooks with the names:
11-XXX-12.xls
11-XXX-13.xls
and containing only the records which belongs to column E.
Anybody idea how to setup this?
A star for the golden solution!