Advance Filter VBA Code

[anishkumarvs]

Hi
I am looking for VBA code to filter the data from a sheet when a condition is met.

If an invoice number matches to a cell value, I need the macro filter the data for that invoice number and copy paste the into new excel.

I might have the same invoice number multiple times which has to be captured.

vendor INVOICE NO transactions TOTAL AMOUNT
12345 1500040059 5 500.00
12345 1500040059 2 200.00
12345 1500040059 2 200.00
36453 1060582129 122 1220.00
36453 1060582129 25 250.00
36453 1060582129 1 10.00

Looking forward for a response.
Thank you

[ranman256]

record a macro,
filter your data on an invoice
save the macro.
edit the macro
then add at the end
ActiveSheet.Range("a1").CurrentRegion.Select
Selection.Copy
Worksheets.Add
ActiveSheet.Paste

[anishkumarvs]

Hi..thank u for the response. But i am not sure if that will work for me. Im looking to run it multiple times through loop.
Thanks