Hi,
I have a workbook which is called test.xls.

The following is the content of the test

ID custid amt
001 xxx 1000
001 yyy 2000
002 mmm 3000
002 ttt 500
002 nnn 2500

Now is there a way to loop through the above in excel and export the above data in two different workbook such that content of the first workbook is

ID custid amt
001 xxx 1000
001 yyy 2000

and the content of the second workbook will be
ID custid amt
002 mmm 3000
002 ttt 500
002 nnn 2500

The name of the first workbook will be 001.xls while the name of the second workbook will be 002.xls.
Thanks for any help.