Separate one workbook into multiple workbook based on country

[livelyzd]

I have a workbook contains sales data for many countries (see attachment) Sales Data.zipand I frequently need to separate the file into multiple work files, one files contains only 1 country's sales data, the the file should be named under the country. It is really time consuming... How can I automate the separation process? thanks a million!

[Fotis1991]

Welcome to the forum.

This code should do what you need.

Please Login or Register  to view this content.

[livelyzd]

WOW Fotis this is amazing!! Many thanks~~~
However, I think I was not clear on the meaning of "files".
By saying "files" I actually mean workbooks. So instead of separating worksheets I will need the workbooks....

But this is already very good!!!
If possible can help to make into workbooks?

[Fotis1991]

3 Points!

1) You are welcome!

2) Unfortumately i am not able for helping you to create multiply Workbooks.


3) Pls

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

[HaHoBe]

Hi, Fotis1991,

if I may help out on this one (just added a couple of lines and marked them with a comment):

Please Login or Register  to view this content.

I substituted Range("A65536") with Range("A" & Rows.Count) which will reflect the available number of rows for the "new" workbooks from 2007 on.

Ciao,
Holger

[Fotis1991]

@ HaHoBe

Really nice. Thanks for adding this!

Let's see what OP says!!

[livelyzd]

Thanks guys for the help!!

[Fotis1991]

You are welcome and thanks for the feed back.

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.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[prabhubox@yahoo.com]

Hi Friends,

Good to see this, i required a small change in it , instead of saving separate file, kindly help to send the workbook as a attachment country wise to the specified mail id.

Example for Singapore workbook to be sent to aaaa...@ gamil.com and Malaysia to bbb..@gamil.com

kindly do the needful.

Prabhu

[Fotis1991]

Pls start your own thread as per forum rules.

[Phil_Lloyd_1979]

Hi Holger,

The above code works for a similar exercise I am doing however I wondered if you could assist with my query. I am looking to create separate files based on a line manager field, in my case column M. Please can you advise how I can do this so my sheet is split into several files by Manager name.

Regards

Phil

[Fotis1991]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

I have already replied to your other thread.