copy full row to another sheet if conditions are satisfied

I request experts of this forum to help me in creating code to copy full row to another sheet if conditions are satisfied


copy full row from Sheet1 to Sheet2 if conditions are met.

CONDITIONS:-

1 Col. "FROM" of Sheet1 is >= col. T4 of sheet 2
AND
2 Col. "TO" of Sheet1 is <= col. T5 of sheet 2
AND
3 Col. "ITEM CODE" of Sheet1 is =col. R9 0r S9 or T9 0r U9 0r V9 of sheet 2

Expected result in Sheet-2

Hope somebody will help me.

According to your attachment a VBA demonstration for starters to paste to the Sheet2 worksheet module :

PHP Code: 

Sub Demo1()
    With Sheet1
        .[Q2].Formula = Replace("=AND(F2>='#'!$T$4,G2<='#'!$T$5,ISNUMBER(MATCH(J2,'#'!$R$9:$V$9,0)))", "#", Name)
        .[A1].CurrentRegion.AdvancedFilter 2, .[Q1:Q2], [C1:Q1]
        .[Q2].Clear
    End With
End Sub 


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

Code is not working "runtime error 1004" Application-defined or object-defined error"(refer attachments)
debug error at .[Q2].Formula = Replace("=AND(F2>='#'!$T$4,G2<='#'!$T$5,ISNUMBER(MATCH(J2,'#'!$R$9:$V$9,0)))", "#", Name)
Kindly provide solution.

Originally Posted by kv.singh

Code is not working "runtime error 1004" Application-defined or object-defined error"(refer attachments)

As it works a treat on my side so according to your pictures you felt in the bad readers trap !
Just well read and apply the dark red direction in post #2 …

Thanks Murthy your code is giving desired result.
@Marc L sorry for inconvenience but I still not understand what you want to explain.