Splitting a Worsheet into multiple files based on Cell Value

[Phil_Lloyd_1979]

I have a report which details multiple fields and one of the columns is manager name.

This report is 3,000 rows long however I am looking to create a separate file for each individual line manager.

I understand a code can be written into VBA which when run will split the sheet into multiple files.

Any hekp on this matter would be greatkly appreciated.

Phil

[Fotis1991]

I had another same issue some time ago. See if this helps you.

Please Login or Register  to view this content.

[Phil_Lloyd_1979]

Hi Fotis,

Many thanks for your help. The code you provide actually splits the sheet into multiple sheetsm, I am looking to create separate files. Also, the value I am basing this split on is in Column M.

Hope you are able to look into this for me.

Regards

Phil

[Fotis1991]

Follow the link Phil.

http://www.excelforum.com/excel-prog...n-country.html

[Fotis1991]

Phil

Holger's code in that thread is easy to modified. Insist of column A that both of us used there you have to use column M.

If you can not handle this, then upload a small sample workbook to show you how to do this.

[Phil_Lloyd_1979]

Hi Fotis,

I have amended the references to ranges A to M but this is not working however I moved my column from M to A which worked.

If I add the line manager email address is it possible to add to the macro to create an email, add text and add the respective file?

Regards

Phil

[Fotis1991]

Phil sorry but i don't know(i am talking about your new questions).

But as this is something different from your original question, you can mark this thread as solved and start a new thread with your new questions.

Good luck.

[Phil_Lloyd_1979]

Hi Fotis,

I can't see the mark solved option.

Regards

Phil

[Fotis1991]

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

[Phil_Lloyd_1979]

Hi Fotis,

Further to the above case we have a similar reauest which relates to the above but goes one step further. We want the sheets to be split but then to add a password to each split file. Is there any code to this effect that we can add to the macro?

Regards

Phil