VBA for save individual excel file .. with master file

[santosh226001]

Hello
I wanna a VBA for my excel file with a unique facility…

I have a road master file where we input all necessary information on a road i.e. District Name, Road Name, Length, Senction Cost, Year Block etc… many other.
In this file we store record of many Different District i.e agra, allahabad, unnao, badau, varanasi and soo on…..

I want to VBA Button "PROCESS" in top of my Master Sheet where I click & store 1 district all record to a New Excel file (File Name Automatically District Name).. I think is it possible through VBA …

Example.. if in my master file 30 different dist then through PROCESS button this file save 30 excel file with District Name…

Pls help me…

Here my file is attach
Master file.xls

[mmmarks]

Hi Santhu,
Here is the code: try in test file

Please Login or Register  to view this content.

[santosh226001]

thank for ur quick reply
code working as per my requirement.. but
but in this code record delete for my master file ...
pls dont dlete record form master file..

pls suggest me or edit ur end ur code & send again..