Need A VBA Code for Saparate Workbook of Each Sector in Master Database

[santosh226001]

Hello Sir..
Session Greetings..

Sir we have a database file where aprox 650 sector data in a single worksheet..
now my boss say that they want each sector a single workbook.. so we need a code for easily saparate file

in My sample file Sector Name in Column B.. we want to each saparate file with Sector name .. only single line sector data

Thanks in advance

Santosh

[alansidman]

Why not just use the advanced filter and print off a report.

[davesexcel]

This will do it for you,
Make sure the folders in code matches the folders on the computer.
The files are saving at about 950 kb, not sure why.

Please Login or Register  to view this content.

[santosh226001]

davesexcel sir its works.. thanks a lot