Split data in separate file as per value change in column A

[dingdang]

Hi,


I have xls file which i want to split in to multiple files as per value change in Column A in same folder with file name in Column A.


file attached for your ref. output file will split in to 6 files with file name z400001.xlsx , z400002.xlsx,z400003.xlsx,z400004.xlsx, z400005.xlsx and z400006.xlsx


https://dl.dropbox.com/u/66400357/dummy.xlsx


Pls help. thanx in advance.

 

[Luke M]

Check out Ron's page here:

http://www.rondebruin.nl/copy5.htm