Move entire row from sheet to another based on adjacent cells contain empty cells

Hello
I search for macro to move entire row from COPY sheet to MOVING sheet based on each item in column B contains empty cell for adjacent cell in column A
so when copy to MOVING sheet should delete from COPY sheet and should update in MOVING sheet when change in COPY sheet .
thanks

Hello,

again so confusing !

What do you really need : a VBA procedure scanning all the worksheet at once
or a worksheet event procedure when a cell changes in column A and is empty ?‼

Hi Marc L

What do you really need : a VBA procedure scanning all the worksheet at once

yes this is what I want it , but shouldn't repeat to the bottom when run the macro every time .

What could mean your 'but …' ?‼ As the VBA procedure is scanning all the worksheet when launched …

What could mean your 'but

I said to shouldn't copy to the bottom for the same data have already copied . other meaning in MOVING sheet should clear data before bring them from COPY sheet.

According to the Macro Recorder a starter beginner level VBA procedure to paste only to the MOVING worksheet module :

PHP Code: 

Sub Macro1()
         UsedRange.Clear
    With Worksheet____2.UsedRange.Columns
        .Item(1).AutoFilter 1, "="
      If Application.Subtotal(103, .Item(2)) > 1 Then
        .Copy [A1]
        .Offset(1).Delete xlShiftUp
      End If
        .AutoFilter
    End With
End Sub 


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

thanks !
it shows "application defined error" in this line

Please Login or Register  to view this content.

No clue what you have badly done as it well works on my side with your attachment so back to post #6 ! …

i don't think to make mistake.
you can see the file

Oh yes your bad ‼

As it is very not the initial post attachment - try with it at least ‼ - so you forgot to update the worksheet codename reference !

so you forgot to update the worksheet codename reference !

I'm not sure what you mean?
if you mean 103 I don't understand what is this , I was asking about it.

No as I wrote it's the worksheet CodeName reference as the worksheets CodeNames are not the same between your both attachments ‼

So just download your initial post attachment and try with it …

CodeNames are not the same between your both attachments ‼

I don't understand you !
I'm surprised from your speech . this is the same file I work at it, I downloaded the initial post attachment , still error continues !

thanks again
just delete from COPY sheet without move to MOVING sheet , sorry !
I will come back soon as I can .

@sintek
based on Marc's code the worksheet________2 indicates to COPY sheet to filter data before copy to MOVING sheet if I'm not wrong.
even if that just will delete from COPY sheet without show anything in MOVING sheet.

@Marc L now two both codes don't work , just delete from COPY sheet without copy to MOVING sheet!
now what's my bad !

As my post #15 VBA demonstration well works on my side with your both attachments …

As my post #15 VBA demonstration well works on my side with your both attachments …

Bad news for me !
well maybe else body has alternative.
anyway thanks for your time and try to help me

Marc L's code does work...

may you attach the file work for you ,please?

No problemo ! But just note the codeline UsedRange.Clear is what you asked for since your post #5 ‼

But just note the codeline UsedRange.Clear is what you asked for since your post #5 ‼

yes , that's correct and I admitted in post#25