separate data of differents countries in others sheets

hello!I want to create a macro or formula to separate in differents sheets the data of the same country in the attach file.

thanks a lot in advance!

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets - Part One

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.


For your workbook, all I had to edit was these two lines:

   Set ws = Sheets("Hoja2")


   vTitles = "A3:Z3"

...then the macro parsed out the data to individual sheets as is. Give it a try.

When I made the changes noted in post #3, then put the edited code into a regular code module and ran it, it created all the sheets needed. What did you do?

Post your workbook here with the macro edited and installed in it so I can see how you implemented it, I'm sure we'll spot the problem.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.