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
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.
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
Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks