Delete entire row for different color in VBA

Hi Guys

In column A i have items details & in column B is the color of items.
In an items there are multiple color,i want to keep the first color only & delete entire row of the others color.
How can I do this in VBA?

Untitled.jpg

Hello mehidy,

Here's the code for you:

Please Login or Register  to view this content.

Originally Posted by Buskolsky

Hello mehidy,

Here's the code for you:

Please Login or Register  to view this content.

Thanks a lot.
How can I have the result in a new sheet?

Mehidy,

Posting the result in a new sheet can be done in several ways. Whether you want to create a new sheet every time you run a macro, add new lines to existing sheet or overwrite existing data - the approach will be different. Please be more precisive with your example and perhaps we may come up with something

Originally Posted by Buskolsky

Mehidy,

Posting the result in a new sheet can be done in several ways. Whether you want to create a new sheet every time you run a macro, add new lines to existing sheet or overwrite existing data - the approach will be different. Please be more precisive with your example and perhaps we may come up with something

Hi,
I want to create a new sheet with the result, every time I run this macro.