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...
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?
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:
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...
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.