I AM TRYING TO CREATE VBA CODE TO PULL ALL DATA FROM SHEET 'NB' TO SHEET 'NBD' IF
CONDITION 1 ) VALUE GIVEN IN B2 TO B1OO IN 'AG-MNU' SHEET MATCHES WITH DATA IN
COL J1 TO J100 OF 'NB' SHEET AND
CONDITION 2) DATE RANGE GIVEN BETWEEN T3 TO T5 OF 'AG-MNU' SHEET MATCHES WITH COL.
C2 TO C100 OF 'NB' SHEET'.
BELOW MENTIONED VBA CODE IS PULLING ALL DATA PROM SHEET NB TO SHEET NBD. PROVIDE SOLUTION
Sub PULLDATA()
With Sheets("NBD")
.Cells.Clear
Sheets("NB").Cells(1).CurrentRegion.AdvancedFilter xlFilterCopy, Sheets("AG-MNU").Range("B2:B100"), .Cells(1)
End With
End Sub
Bookmarks