mtthompsons
asked on
I need help with a macro to delete rows
I need help with a macro to delete rows
1. Check column "E" delete all rows completly which has words as remove, cancelled,closed,Closed-fi rst call,Resolved, Rejected and resolved
2. In Column "R" delete all other rows which does not have
TTY.Iyh.Desktop.Dtf
TTY.Iyh.Desktop.Sof
TTY.Imd.Server
TTY.Irh.Network
3. In Column "AA" delete rows that has these cells
Bisteio, Krika
Kuemiud, Riha
Maheqlkr, Hai Vial
Naioeqm, saeh
Naiuak, Trati K
Please note point 1 is delete rows that has these words in row "E" and point 2 is delete all rows which does not have the 4 group names in column "R" and 3rd point is delete just rows that has column "AA" with these 5 names
Thanks
Sample.xlsx
1. Check column "E" delete all rows completly which has words as remove, cancelled,closed,Closed-fi
2. In Column "R" delete all other rows which does not have
TTY.Iyh.Desktop.Dtf
TTY.Iyh.Desktop.Sof
TTY.Imd.Server
TTY.Irh.Network
3. In Column "AA" delete rows that has these cells
Bisteio, Krika
Kuemiud, Riha
Maheqlkr, Hai Vial
Naioeqm, saeh
Naiuak, Trati K
Please note point 1 is delete rows that has these words in row "E" and point 2 is delete all rows which does not have the 4 group names in column "R" and 3rd point is delete just rows that has column "AA" with these 5 names
Thanks
Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you please help with this
https://www.experts-exchange.com/questions/28417333/Insert-2-columns-and-add-a-formula-and-get-stats.html
https://www.experts-exchange.com/questions/28417333/Insert-2-columns-and-add-a-formula-and-get-stats.html
Ron de Bruin has a nice example on his website http://www.rondebruin.nl/win/winfiles/MoreDeleteCode.txt