Split a Master file to individual files.

[Lasantha]

Dear All,

Kindly look into attached excel file. It contains received payment amounts by doctor each month. I want to create separate individual files by doctor.

Could you please check and help me on this. I have to mail individual files separately. It takes long time when I have more doctors.

Thanks for your time.

 

[Hui]

have a look at these two posts

Advanced Filter:
Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[Siba Sankar Badatya]

Hello Hui,

I want a macro where the data will be cut as per the Manager Name and save in the dedicate folder with the same name but without any losing the formula in the excel sheet.

• So once the file is cut and apply the refresh button in order to get the data refreshed in every fields.

can you help with macro.

 

[vletm]

Siba Sankar Badatya
First of all:
This thread belongs to Lasantha's Split a Master file to individual files.
Next: You have already two different solutions ... how many more do You need?

Extract data and save in workbook

Hello Team, I have a master work book which contains all the employee data and every employee has a manager in "U" column, is there a macro available where the Planning Manager name can select and the data automatically save in one workbook in manager name wise irrespective of same manage name...

chandoo.org