Copy Paste Macro Based on Criteria

[Dan_B]

Hi All

I'm sure this one has popped up many times but I can't find one to suit what I am trying to achieve

I want to create a macro that will copy and paste selected rows based on the value in column A

For example

In Column A I will have all my continent names (Europe, Asia, North America etc) and each 1 has 5 rows of information for each continent next to it in Column B

A B

1 EUROPE England
2 France
3 Germany
4 Spain
5 Portugal

So when the macro searches Column A and finds the continent it will copy the data for the whole rows from B1:B5 and paste it into a tab with the same name into the same row numbers (in this example it would copy and paste to a tab called EUROPE into rows B1:B5)

Trying to automate this as I need to do it for every continent and group the countries manually at the minute

Thanks in advance

Dan_B

[Keebellah]

Hi Dan, I suggest a sample workbook so hat we know what the layout is.
Make sure it doesn't contain private or sensitive data.

[Dan_B]

Thanks Keebellah - I've attached the file to this response thread

Hopefully this makes it a bit clearer

[Keebellah]

Okay, makes sense.
The continent only appears once and until the next one appears the data of those rows goes to a new sheet with the name of the continent.
Correct.
What to do with the copied original. clear the contents?

[ImranBhatti]

see if the attached helps you

ctrl + t will fire the macro

[Keebellah]

I assumed that the user dit not want an input box.
This one takes care of it and if there are more countries, the code works.
As long as you just fill in one continent and the the countries it works, so it's 'dynamic'
BTW the macro's name is MakeSheets (no shortcut key)