Find a specific condition and delete everything else

[redeyegravy]

Hello. This is my first time posting to a forum. My need is this...I have a large data set of individual products that fall into one of five segments. I want a macro to find all the items in one segment and do one of 2 things. Either 1) delete all the products that are not in the targeted segment or 2) copy/paste the targeted segment into a separate area.

[patel45]

Please Login or Register  to view this content.

[tigeravatar]

redeyegravy,

Welcome to the forum!
Here's an alternate code that you can use for option 2, copy/paste the target segment into a separate area:

Please Login or Register  to view this content.

[redeyegravy]

patel45...thank you for the reply. If I am understanding your code...

the LR = Cells(Row.count)...basically names the column
For j = LR...names the starting row of the data...basically these 2 lines identify the intersect.

How can I modify your code to just delete the rows. I don't need it to to both.

I tried to eliminate the "next" part of the macro...but the macor blew up because of the "For" naming part.

I'm fairly new to macro functionality...your expertise is greatly appreciated!

Please advise on my above question...

[patel45]

Please Login or Register  to view this content.

[redeyegravy]

thank you patel45! I played around with your code and figured out how to manipulate it for my needs. Also...than you to tigeravatar for the other method for achieving my needs. I really appreciate all the expertise.