Previous Topic Next Topic

Macro needed to delete rows with certain condition.

Closed
tsunamibomb Posts 1 Registration date Tuesday September 23, 2014 Status Member Last seen September 23, 2014 - Sep 23, 2014 at 01:48 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 25, 2014 at 03:26 AM
Hi,

I have about 169,000 lines of items to go through and I'm trying to figure out a macro to delete every row that contains the word "Discontinued". I am going through one by one, but this could take an eternity. If someone can please help me out, it'd be much appreciated!

Thanks, Linda

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 25, 2014 at 03:26 AM
filter according to that specific column and criteria being that string and delete FILTERED DATA ONLY and then remove filter. be careful test with experiment data. also keep original data safe somewhere for retrieval if something goes wrong.,
0