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
1864
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 reply

Answer 1 / 1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 805
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