Split rows of table to new worksheets

[JorgeOtavio]

Hello Friends.

I would like to ask you for helping me with a VBA code.

I want to split rows of a table in worksheets based on a column content. This picture below shows what i would like to have it. I need to split based on column B, each color has a group of name, and base on it i want to split.

 

[vladimiratanasiu]

Hello Friends.

I would like to ask you for helping me with a VBA code.

I want to split rows of a table in worksheets based on a column content. This picture below shows what i would like to have it. I need to split based on column B, each color has a group of name, and base on it i want to split.
View attachment 71941

See Split Data into Multiple Worksheets Based on Column - Free Excel Tutorial