HELP! - VBA to VLookup, Copy & Paste

[Joey86]

Hi Guys,

I really need help trying to get a VBA macro to do a Vlookup on another sheet then to find all the rows with that value, then copy them and paste them on another sheet, hopefully this is possible and that someone can help cause I don't have any knowledge on VBA.

Ok so I have 2 sheets, 'Daily Report' and 'Exceptions'. On the 'Daily Report' sheet when a user changes the sections in yellow shown below, I'm needing the macro to go to the 'Exceptions' page and lookup that selection criteria then copy all the values (might be more than 1 row) then it needs to come back to the 'Daily Report' sheet and paste the values down below in the green.

Daily Report Sheet

Exceptions Sheet

 

[Joey86]

I've recorded the steps to it now, is there a way for it to run when field F7 changes?

Sub CustomerExceptions()'
' CustomerExceptions Macro
'


'
    Sheets("Exceptions").Range("Table_owssvr_13[#All]").AdvancedFilter Action:= _
        xlFilterCopy, CriteriaRange:=Sheets("Consolidated Daily Report").Range("B10:B11"), CopyToRange:= _
        Range("'Consolidated Daily Report'!Extract"), Unique:=False
End Sub

 

[Andrew Poulsom]

You can use the Worksheet_Change event procedure:

Events In Excel VBA

 

[Joey86]

Thanks for all your help Andrew, really appreciate it