[SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column [Archive]

View Full Version : [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column

NWA John

03-12-2023, 11:14 AM

I Need to Delete each row that has "Daily Ledger Bal" I cannot get "Filter" to work or "Find & Replace" identifies them but leaves the row intact.

Date
Ref/Check
Description
Amount
Balance
Memo
Category

03/16/2023

Pending: CKCD AUTH 03/13 Prime Video TV
-4.38
4760.73

03/16/2023

Pending: CKCD AUTH 03/13 GOOGLE *YOUTUB
-13.16
4765.11

03/13/2023

Pending: AC-NewYorkLife-AARP-INSURANCE
-124.95
4778.27

03/11/2023

Daily Ledger Bal

4903.22

03/10/2023

03/10 09:05 CA CKCD DEBIT 8040
-7.82
4903.22

Entertainment

03/10/2023

03/10 10:10 WAL-MART #7242 FARMINGTON AR POS DEBIT 6507
-215.55
4911.04

Shopping

03/09/2023

Daily Ledger Bal

5126.59

03/09/2023

AC-BLACK HILLS ENRG-UTIL BILL
-144.84
5126.59

Bill

03/09/2023

03/07 22:25 PAYPAL *PYPL PAY 8882211161 CA CKCD DEBIT 8040
-23.97
5271.43

Other

03/08/2023

Daily Ledger Bal

5295.4

03/08/2023

AC-CAPITAL ONE -CRCARDPMT
-149
5295.40

Credit Card Payment

03/08/2023

AC-CAPITAL ONE -CRCARDPMT
-61
5444.40

Credit Card Payment

03/08/2023

03/07 02:34 COLLIER DRUG FAR FARMINGTON AR CKCD DEBIT 6507
-179.07
5505.40

Medical

03/08/2023

03/07 08:58 WEDINGTON ANIM FAYETTEVILLE AR CKCD DEBIT 6507
-30
5684.47

Other

03/08/2023

AC-SSA TREAS 310 -XXSOC SEC
2151
5714.47

Deposit

03/07/2023

Daily Ledger Bal

3563.47

03/07/2023
1001
PRIORITY 5 CHECK
-60
3563.47

Other

03/07/2023

AC-SYNCHRONY BANK -PAYMENT
-150
3623.47

Credit Card Payment

03/07/2023

03/06 23:19 866-712-7753 CA CKCD DEBIT 8040
-6.99
3773.47

Entertainment

03/06/2023

Daily Ledger Bal

3780.46

03/06/2023

AC-CITY FAYETTEVILL-UTILITYPMT
-88.58
3780.46

Bill

03/06/2023

AC-OZARKS ELECTRIC -PPDDRAFT
-88.33
3869.04

Bill

03/06/2023

AC-OZARKS ELECTRIC -PPDDRAFT
-54.9
3957.37

Bill

03/06/2023

03/03 22:16 SQ *JANET LYONS Farmington AR CKCD DEBIT 6507
-45
4012.27

Groceries

03/06/2023

03/05 22:18 ADOBE *PRODUCTS 4085366000 CA CKCD DEBIT 8040
-9.99
4057.27

Entertainment

03/04/2023

Daily Ledger Bal

4067.26

03/03/2023

AC-USAA CHK-INTRNT -TRANSFER
-100
4067.26

Transfer

03/03/2023

03/03 10:58 KUM&GO 0423 FARM FARMINGTON AR CKCD DEBIT 6507
-38.57
4167.26

Gas/Transport

03/02/2023

Daily Ledger Bal

4205.83

June7

03-12-2023, 12:17 PM

Do you really want to delete row or just hide it? Filter works for me. Why does it not work for you?

NWA John

03-12-2023, 12:42 PM

Thanks for the reply. When recording a macro to filter out the "Daily Ledger Bal" I get the "
Too Many Line continuations" error. My VBA is not good enough to manually write the code for filtering out the rows with "Daily Ledger Bal" )-:. If you have any other suggestion as to how I could make this happen, I would sure appreciate it.

June7

03-12-2023, 12:57 PM

NWA John

03-12-2023, 01:26 PM

Select "Text Filters" from filter dropdown and then "does not equal". Macro recorder produced:
ActiveSheet.Range("$A$1:$C$6").AutoFilter Field:=3, Criteria1:= "<>Daily Ledger Bal", Operator:=xlAnd
or try "begins with" or "does not contain" and see what recorder produces.

Thanks again for all of you men & women who volunteer your time, for free, to your fellow Excel users.

Before I tried your solution, I noticed that the cell in the next column to the "daily Ledger Bal" cell was always empty. Then I used Go To -> special and searched for all blank cells in that column. Once selected, it was easy enough to use Delete Row to get rid of all the blank cells & rows with "Daily Ledger Bal" in them.

I should have noticed this before, but you inspired me to look for alternative ways to accomplish this. I am sure you would laugh at my VBA code, But I just celebrate if it works (-:

Thanks again....

Aussiebear

03-12-2023, 01:48 PM

@NWA John, since it appears you have a solution, would you kindly go to the Thread Tools Option and select the Mark thread as "Solved" option please?

Aussiebear

03-12-2023, 04:18 PM

Thank you NWA John