remove rows vba script

  1. C

    Removing lines based on multiple criteria

    I am trying to eliminate certain rows in my workbook automatically based on a few fields. The file contains patient encounters with hospitals. Patient can either be discharged from the ED, admitted to inpatient, or discharged from inpatient. If a patient is transferred to inpatient from the...
  2. L

    remove rows which contain words from range on other sheet

    Hi All, I need to exclude rows from ie sheet1.Range(A1:A200) which contain keywords from cells in sheet2.Range("I2:I50"). At the moment I am using array but I want the words to be taken from range in case user what to change these keywords. Could anyone help me with this? Thank you Code...
  3. 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...
  4. N

    VBA Remove Table Rows

    I've taken my data and converted it into an Excel table. I'm trying to delete any rows within the table that have the value "H" in Column U. Can anyone assist? I've unsuccessfully tried using a few different variations of code that I've found on various forums, but I'm wondering if there is...
  5. selant

    How to remove the required rows with vba

    Hi, Can you help me write a VBA script to remove the required rows shown in the figure. The range will be A1 to F9. I want to remove the rows which Grade1, Grade2 and Grade3 columns are zero at the same time. Thank you.

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...