remove rows

Hi all My excel knowledge is beginner at best! Need your help! I want to remove a complete row if cell B5 and below, and D5 and below are BOTH blank or show " " result from another worksheet. Many thanks

I have the following code that deletes the entire row if its value is 900. Sub RemoveRows900() Dim i As Long i = 1 Do While i <= ThisWorkbook.ActiveSheet.Range("AA7:AA1000").CurrentRegion.Rows.Count If InStr(1, ThisWorkbook.ActiveSheet.Cells(i, 1).Text, "900", vbTextCompare) > 0...

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

Hello Folks, This may be a quick one but my strengths are not in VBA [/URL][/IMG] I have a Source sheet that is linked to 1000s of formula and the whole thing is running horrifically slow. I need a way to eliminate unnecessary rows from the source data in a fully automated way. Luckily the...

Hello, I need to set up a power query so that it for each Text file that is in a folder the top 8 and bottom 4 rows are deleted when imported. Is this possible and if so how do I do it?

How can I remove rows based on cell contents being 'null'. I could manually do it in excel by using special to delete them but would like it as part of the query. My column which appears about halfway across my sheet is this. edit: number4 is the column header. <tbody> number4 null...

I'm working on this workbook in Excel 2010. Each Monday I run a query of a backlog that is hundreds of rows long. Many of the rows are the same from week to week but there are always new rows and occasionally one of the old rows will be removed. Ideally, I would like to be able keep one main...

How can I remove rows from my spreadsheet that don't subtotal Zero in the Subtotaled "CPT" Column. I only want to leave the group of data that has a subtotal of Zero in the "CPT" Column. This is the complete Sheet <TBODY> Practice Code Appt Date Pat Person Nbr Pat First Name Pat Last Name...

Hi all, I have two sheets. Sheet 1 has 73.619 rows and sheet 2 has 41.470 rows. The values of column A in sheet 2 appear randomly in column A of sheet 1. I want to do 2 things: 1. I want to delete all rows in sheet 1 that have a value in column A that can not be found in column A of sheet...