How to filter data using multiple Criteria using vba

Hi
i am filter data using multiple criteria with below codes

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

i want to apply all of above code at once to my filter

thank you

Hello HaroonSid,

I would like to try a few possible options, but not by trying to recreate what I think your Workbook and Data might look like.

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.

Do you need all the criteria sets exactly as you have now, or is it possible to simply combine the arrays? In other words, could you have say "92" in column H and "LJT" in column J, which would not meet any of the three criteria sets above, but would match if you simply combine all the arrays.

@ xlnitwit,

Exactly my take on it as well. If we had a sample Workbook, we could test accordingly.

Regards.

Sorry for late reply
here is sample workbook and a screenshot with result as i need,
i want to combine all three macro's result like screenshot
A.JPG

I think you will need an advanced filter for that rather than an autofilter. Is it OK to set that up in the file?

Yes i know but how to do with vba
thanks