row delete

When i apply filter , it should uncheck only John and apply filter to all the values except john and delete the rows till last value Mark Name 80 John 20 Maya 30 John 40 Peter In my report , John is the standard person. But Names daily will get change. I need to delete the rows...

Hi, I have a file which has the following information in Column A : <tbody> Project: ABC 1 34 45 Total Project: XYZ 3 56 Total I would like to all rows which do not contain "Project:" or "Total" to be deleted IN this case, the final output should look like this : Project :ABC Total...

I have a worksheet with 10 columns, two of which (J and K). J column takes various text values, one of which is "External Research". K column takes year values (they are formatted as "General" type), starting 2001. I want to delete the whole row, when J is "External Research" or K is <=2015...

Frnds, I need a Macro to delete rows in excel to cell with specific keyword "Job Number" in excel and next find if cell exactly next row is blank, if yes then delete this row with blank cell and above two. NB, If its a blank records then it will only be single blank row below "Job No" as...

I have this code however it is not doing what I need it to do: Sheets("IG MEDCO").Select Dim CelIGMEDCO0F As Range, RngIGMEDCO0F As Range, iIGMEDCO0F As Long Set RngIGMEDCO0F = Columns("I").SpecialCells(xlConstants, xlTextValues) For iIGMEDCO0F = RngIGMEDCO0F.Count To 1 Step -1 If...

Hello, I need help writing code that will search for a name, which a column may have multiple, then look to another column and delete each row that has a lower value than the high value. so for example, search for john A B 1 John .5 2 John .7 3...

I am using Excel 2007 and with a .vbs file and I am trying to delete the first 11 rows of data in a CSV, then delete the very last row after the first 11 are deleted. After this the file should be saved in XLXS format which currently does work. Set objExcel =...

Hello, Thanks to the members of this forum i have gone from completely clueless to beginning novice in vba. To improve, I am trying to get in the habit of creating code that is more efficient and faster. I usually create for loops to run through the data in excel to delete unwanted values...