delete row on condition

  1. J

    Help!!!! Vba code to delete rows in one sheet based on criteria from another sheet...

    Hi I am a newbie to Excel VBA Coding so take it easy on me i this is a stupid question. So, I will try to explain what I need as best I can: So, I have a spreadsheet (we'll call it S1) that has over 3000 rows of data. Each row corresponds to a customer that has various customer related columns...
    • jyeezo83
    • Thread
    • delete row delete row macro delete row on condition delete rows vba
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Not Enough Memory - Remove Rows Containing Blank Values in Specified Column From All Open Workbooks

    I have been using a macro to pull together worksheets from all open workbooks into a single sheet discussed here: Combining All Open Workbooks into Single Worksheet I then have another macro I have been using that removes a row if there is no value within a specified column shown here: Sub...
    • SGMacro
    • Thread
    • combining workbooks combining worksheets delete row on cell value delete row on condition remove rows vba script
    • Replies: 2
    • Forum: Excel Questions
  3. C

    VBA macro: Delete Rows based on different Criterias

    Hi all, First and foremost happy holidays and thank you</SPAN></SPAN> for any help provided. I have copied a code from internet and I would like to modify it but dont know how ? In the code below: it deletes the entire row rows based on the criteria different "RVWD" . I would to modify it so...
  4. S

    VBA delete row if cell is blank

    Just learning vba and trying to put it together. If I want to delete a row if a value in its column is blank. So if it was column F and starting from F1. F1 & F2 are blank and F8 & F9 are blank etc i would want to delete rows 1,2 & 8,9. This is how I am setting it up but cannot get it to...
    • Sayth
    • Thread
    • delete row on cell value delete row on condition vba
    • Replies: 26
    • Forum: Excel Questions
  5. S

    Macro to delete entire row if a cell in column m has number zero.

    Hi everyone,, IN great need of a code to delete ENTIRE ROW if a cell in COLUMN M has number 0. my range is from row 2 to row 3745, and there is blank row every after 34 rows. for example there is data from ROW 2 TO ROW 35 then there is blank row and so on.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top