-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
delete row if condition
-
A
Delete Rows That Do Not Meet Criteria
Hello, I am working in a 3,300 row excel sheet and I would like to delete the rows that I don't need. I want to delete rows that do not contain a certain NAICS classification, do not occur in a certain states, and will be awarded via "sole source" (I work in contracting). I have tried several...- Aschr13
- Thread
- delete all values that do not contain delete row delete row if condition delete row if condition is not met delete row multiple criteria delete row when criteria is not met
- Replies: 11
- Forum: Excel Questions
-
M
Delete Row based on Last Word
Hello all, i want to delete the entire row if last word is not equal to "OK". I have created a macro, but it is deleting all the rows in the column instead of particular rows where last word is not equal to "OK". Thank you Sub DelD() Dim cel As Range Dim Rng As Range Set Rng = Range("A2:A" &...- madhuchelliah
- Thread
- delete row if condition last word
- Replies: 3
- Forum: Excel Questions
-
D
Macro to delete rows based on cell values in a range - dynamic rows and columns
Hello team, I would like to ask for help with the following macro as I just can't figure it out, I tried so many versions but nothing worked for me. I need to remove all rows in my sheet that do not contain value greater than 50 in any cell in a given row. That means that if the value is less...- Dany46
- Thread
- delete row delete row if condition delete row on cell value dynamic range
- Replies: 15
- Forum: Excel Questions
-
T
VBA - Search workbook for list in sheet1, and delete all rows containing those values
I found similar requests here, but nothing that I could make work for what I needed. I have a list of over 200 inactive part numbers (and more may need to be added) in Sheet1 column A. In all other sheets in the workbook I want to search through column C, starting at row 8, and delete the row...- The Power Loon
- Thread
- delete row if condition search vba
- Replies: 6
- Forum: Excel Questions
-
F
Deleting rows based on a variable in 1 column
hello, I have created some code that will delete an entire row based on if the value 1 is in the column or not. The code works but takes 40 minutes to run on 300,000 lines. Is there a better method to make this work? Sub Delete_Rows() Dim i As Long Dim LastRow As Long...- forensic93
- Thread
- code delete row delete row if condition vba
- Replies: 8
- Forum: Excel Questions
-
S
VBA delete row if date contained however skip if blank
Hello, I am looking for a vba that will do the follow. If the cell a2 date value is not the date value of the cells below delete the row however if the cell is blank within the column do nothing and move on to the next cell. <tbody> a b 1 2 7/22/2019 21:04 3 7/22/2019 20:55 4...- Sparda142
- Thread
- 7/22/2019 cell date value delete row if condition vba if and
- Replies: 1
- Forum: Excel Questions
-
L
Repeat until value not found in column
Hello everybody I need same help. I need to delete rows with the value 0 in column B I made this: Columns("B:B").Select Selection.Find(What:="0", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _...- LuisVilarMoreira
- Thread
- column delete row if condition repeat repeat until rows
- Replies: 3
- Forum: Excel Questions
-
G
VBA delet avery 11 value if not text( or if number is true), and loop on
Hi , my question is how to loop through the range( column) and delete every 11th value if it is a number, or if it is not a text( both works). Product product name 123 123 1234 435 564 234 345 3245 NONO 234 So here on the 11th row, I have a text I would like it to be deleted ( whole row) if...- Gokuba
- Thread
- delete row if condition lastrow loop text vba
- Replies: 6
- Forum: Excel Questions
