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
Bookmarks