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