Hi
I want macro for pull data with given criteria put filter for that data then copy paste in new workbook criteria is 5 to 6 cells with different header
To help us/you out, I'd suggest recording a macro of you applying the filter (either regular or advanced), copy the data to a new workbook. That should either get you started, or provide us the structure of your workbook and then we can tweak it.
I don't see any uploaded files.
The article you linked to shows how to use the Advanced Filter. The AF can handle multiple criteria in one column...you just list them all under a single heading in your criteria range.