Macro for copy data and paste in separate file

[satheshkalavakunta]

Hi All,

Need your help!!

I am beginner in excel macro i am trying write code with VBA to save separate file in a different folder.

Attached is the sample file. Based on column A, i need to copy data of each number and copy to separate workbook and saved in different drive (D://Sathesh).

Example:

i have 4 different accounts in attached file. Copy the data of 10001 from "A:D" and save the file with filename as 10001.xlsx and so on till it finds empty cell in Column A.

Thanks in advance