Order Spreadsheet Filter, Copy/Paste Data

[KGEORGE13]

Hello,

I have a giant order spreadsheet where I need to continuously filter roughly 100 parts from 1000 possible parts in a column from a table. I tried VBA criteria code but there is just no way it goes through all 100. All orders are placed in sheet : "ORDERS" and i want the parts I need filtered to be Copy and Pasted to sheet: "PARTS". The sheets need to be interactive so when an order is added/deleted, those criteria parts are added/deleted to the "PARTS" sheet.

Anything helps!

Thank you!

 

[oldbrewer]

make up a little 10 part spreadsheet and show us what you want, when issue is sorted you can scale up...

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1057538-ongoing-interactive-filtering.html#post5078667

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).