Group same value in A column and write them in different Tabs

Hello anyone,


I would like to group all the same value in A column and put them automatically in each separate tab:


column A:

Line1 Mark
Line2 Mark
Line3 Mark
Line4 Lea
Line5 Lea
Line6 Lea
Line7 Lea

Column B:

Line1 123
Line2 264
Line3 777
Line4 273
Line5 622
Line6 099
Line7 121

So, I would like to write a VBA that group me automatically all the data that starts with Mark (and related value in column B) in one separate tab called Mark, and all the data that starts with Lea (and realated value in column B) in another tab called Lea....

Thank you so much for any suggestion..

Excel file needed

Screen Shot 2015-03-11 at 11.39.17.png

So, would like to group the same data that with Mark in one tab, and data with Lea in another tab.

Many thanks

Maybe:

Please Login or Register  to view this content.