Delete entire row based on last part of item matches with sheet name

**Ali-M** · 08-31-2023, 11:56 PM

I search for macro to delete entire row for DAILY sheet if the last part of item contains the same sheets names when matching with others sheets names
you will note the last part in item in column B for daily sheet will contain names OMAR, ALI and there are sheets names(OMAR,ALI) then will delete entire row contains names sheets from DAILY sheet to be like as I put the expected result , should be in DAILY sheet
I will add new sheets and add new data in DAILY sheet every time
the data could reach 4000 rows in DAILY sheet and the sheets could be 20sheets.
also I posted here
https://www.mrexcel.com/board/thread...-name.1243958/
and no answering so far !

I hope find help here.

**jindon** · 09-01-2023, 12:31 AM

Please Login or Register  to view this content.

**Marc L** · 09-01-2023, 06:18 AM

Originally Posted by Ali-M

also I posted here
and no answering so far

Hoping you've understood where to not waste time anymore …

**Ali-M** · 09-01-2023, 06:49 AM

@jindon
that's great!
this is exactly what I want it .

thank you so much.

**Ali-M** · 09-01-2023, 06:57 AM

Hoping you've understood where to not waste time anymore …

jindon doesn't say that , obviously my thread is clear .

it's not necessary no answer in the other form mean my subject is not clear . maybe the members who master vba couldn't available.
even if I suppose this is not clear , but my subject is not worse to any member ignore my subject.
I no know why to say that . even my previous thread you don't try to help me what I ask you for my mistake so I left the previous thread without ask you again because obviously you don't want answer me .

**Marc L** · 09-01-2023, 07:00 AM

Well you misread my post so you badly misunderstood as the subject is not me, neither about my help
but where you have first created your thread ‼

As I have no clue about which thread you are stating about so attach at least a link …

**Ali-M** · 09-01-2023, 08:12 AM

@jindon
based on your code will delete any row contains FROM & TO words but not delete in all of cases .
as I said

if the last part of item contains the same sheets names when matching with others sheets names

well I don't post some data for this case , so doesn't the match with sheet name
when you find some names after FROM and TO are not matched with sheet name, then shouldn't delete them so I edited file by highlighted rows in DAILY sheet should keep it , expected result .
I hope you have time to see it.

**Ali-M** · 09-01-2023, 08:18 AM

Well you misread my post so you badly misunderstood as the subject is not me, neither about my help

sorry from your comment I understood my subject is not clear when you say

to not waste time anymore

well I asked RIGHT function in my previous thread how merge with IF function by vba to adapt with my mistake(POSTS#21,22).

https://www.excelforum.com/excel-pro...ml#post5862968

**Marc L** · 09-01-2023, 08:26 AM

But I answered, did you try to make any effort - very beginner level Excel formula - at least ?‼
As I'm not a mind reader, as you did not answer and according to the obvious easy formula so on my side it was already solved …

**Mumps1** · 09-01-2023, 09:10 AM

Some of the Account Names in column B have trailing spaces. Before trying this macro delete any trailing spaces in column B.

Please Login or Register  to view this content.

**jindon** · 09-01-2023, 09:13 AM

Ali-M

Such thing is quite annoying, because of your poor sample workbook.

Please Login or Register  to view this content.

**Marc L** · 09-01-2023, 09:23 AM

Originally Posted by Mumps1

Some of the Account Names in column B have trailing spaces.

Indeed, but no matters when not relative to 'OMAR' & 'ALI' …

**Mumps1** · 09-01-2023, 09:26 AM

@Marc L
If not deleted, the trailing spaces affect the value of:

Please Login or Register  to view this content.

**Marc L** · 09-01-2023, 09:59 AM

Ok Mumps1. (just using Trim …)

Anyway according to the original post attachment as it is a starter VBA demonstration to paste only to DAILY worksheet module :

PHP Code:


Sub Demo2() 
    Dim S$(), N&, Rc As Range 
        If Sheets.Count = Index Then Exit Sub 
        ReDim S(Index + 1 To Sheets.Count) 
        For N = Index + 1 To Sheets.Count:  S(N) = Sheets(N).Name:  Next 
        Application.ScreenUpdating = False 
   With [A1].CurrentRegion 
    For Each Rc In .Range("B2:B" & .Rows.Count) 
        If IsNumeric(Application.Match(Mid(Rc, InStrRev(Rc, " ") + 1), S, 0)) Then Rc.ClearContents 
    Next 
        If IsEmpty(.Cells(2).End(xlDown)(0)) Then .Columns(2).SpecialCells(4).EntireRow.Delete 
   End With 
        Application.ScreenUpdating = True 
End Sub

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

**Ali-M** · 09-01-2023, 11:34 AM

Such thing is quite annoying, because of your poor sample workbook.

sorry about it !
it's perfect .
thanks again.

**Ali-M** · 09-01-2023, 11:38 AM

some of the Account Names in column B have trailing spaces.

thanks for inform me , seem the reason to be from the spaces will show mismatch error in this line

Please Login or Register  to view this content.

when I delete the spaces the code works greatly .

thank you so much, Mumps.

**Mumps1** · 09-01-2023, 11:40 AM

You are very welcome.

**Ali-M** · 09-01-2023, 11:41 AM

that's very great , Marc !

But I answered, did you try to make any effort - very beginner level Excel formula - at least ?‼

I will comment in the other thread as I provided the link in post#8. I don't think good idea to comment here .
thank you for answering here.

Delete entire row based on last part of item matches with sheet name

LinkBack

Thread Tools

Rate This Thread

Display

Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Try this !

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Re: Delete entire row based on last part of item matches with sheet name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] delete characters based on match part of item for helper column across sheets.

[SOLVED] delete entire row if doesn't matches

Delete Entire Row on Every Sheet if Date Condition Matches

delete entire row based on part of a cell value

Filtered ListBox Selected item delete in sheet Entire Row

[SOLVED] Delete entire row based on cell value in another sheet

Copy part of a row to a new sheet then delete whole row based on text value

Bookmarks

Bookmarks

Posting Permissions