Creating excel workbooks based on different values in a column
Posted on 2014-03-06
I want to write a vbscript to be able to create new workbooks based on different values in a column: e.g.
If i have data in an excel sheet like above, i need to have three excel workbooks created in a folder, such that:
1st workbook should be A-B.xls which has elements with type A-B, 2nd workbook should be B-C which has elements with type B-C, and the 3rd workbook should have elements with type C-D.