Vba macros to auto filter on multiple criteria from another sheet

[hecgroups]

Hello Again,

I would be appreciate if some one help me. I have 2 worksheets. First 1 is data which have master list and another one is the list of specific data.

Now the macros will do the following:-

1. Look for a code from the worksheets list (Column A) into worksheets data in column D
2. Look for a Status from the worksheets list (COlumn C) into worksheets data in column F
3. And look for a Dates from worksheet list (Start date column D & End date in column E) into worksheets data column C.

If the criteria match then copy specific columns (Excluding Column F, I, J, K & R) entire rows and past to worksheets statement.

Below are the columns data need to copy

Receiving Date (Column A), Settlement Date (Column B), Billing Month (Column B), Provider Code (Column D), Provider Name (Column E), Batch No. (Column G)
Total claims (Column G), Claimed Amount (Column G), Net Amount (Column M), Rejected Amount (Column N), Approved Amount (Column O), Billing Difference (Column P)
and Rej% (Column Q)

Copy of the sample file is attached for your reference with the output.