Formatting the Master data with incorrect macro

[Deepa12]

Hi

I have a master data which contains the details such as country, name, ID, grade etc.
Can anyone suggest a macro to split the master data based on the country's name and create additional sheets with this data.
I have another macro which helps in tabulation of the data based on a certain criteria but unbale to tweak the same to fit my current simple criteria. As i am new and still learning how to use macro,kindly help me

Below is the tweaked code which when used shows an error

Please Login or Register  to view this content.

Thanks

I have attached the sample data

[Moo the Dog]

See my attached modified workbook and let me know if it works for what you need. I deleted your first three rows on your Master sheet so that the first row of actual data in in row 2. (Row 1 contains the row headings.)

Once you open my modified sheet, run the macro 'CopyCountry'. If the sheet for a specific country already exists, it will add the matching data to that sheet after the last current row of data on that sheet. Since you already had 'India' and 'China' sheets, it won't create anything, it will just copy the data to them.

If the sheet doesn't exist, it will create a new sheet with the country's name and copy the data to it.

Your original 'Master' sheet will remain unchanged.
The code used is as follows:

Please Login or Register  to view this content.

- Moo

[Deepa12]

Cool it works!! thankyou so much.....however i have one more concern which flows from the data to the next step..will get in touch with you soon.........

[Moo the Dog]

Glad to help. Thanks for the rep. It's always appreciated.

- Moo

[jindon]

Deepa12

Re: your PM

You took a wrong code and even your modification doesn't make sense at all....

Please Login or Register  to view this content.

[Deepa12]

Thanks Moo.......

However when i run the macro, the first row which is the header does not appear across other sheets with the ouput data....
can anything be done for it?

[Moo the Dog]

Sure, see the line I added in the code (red text). Add it in to the code in your workbook exactly where it appears below:

Please Login or Register  to view this content.

- Moo