Subject;- Formula for Advance filter on multiple criteria for separate each filtered instance as new file.
I have a code for advance filter & separate each filtered instance as an excel file.
This code filter data for each unique number entered under columns “U”.
You can also check yourself this success code (This code , Regards & always be thankful, for valuable Gift -forever useful, from this site, From helping experts on Chandoo.org) by put Heading as "Buy" at U1, & put buyer numbers under columns U (,U1 have heading) (any criteria heading on which you want to filter, criteria heading should must be same as database's column heading) in row 2 (U2) for test like byer no 11306 , 11305, 11302 after run code from VBA, From module 1, code generate files for that buyer nos..
Till now , code working fine for criteria for under U1 for particular heading to end …now there are requirement for add more criteria, require to cover more conditions
Advance filter till now run for on which ever under column “U”.
If there are formula in under columns “U”, then also advance fitter run for that formula…
But I can not set formula for that that cover more conditions mentioned at right side’s columns for filter
I want to cover conditions is for filter data for particular 1 buyer no between particular dates , & for particular type, particular quality no, particular date etc.
(for between date, Columns W’s heading is Confirmation Date & starting date like >10/10/2017 & column X’s heading also Confirmation Date for like <20/11/2017).
Particular types as you can see in attached requirement screen shot..
Its natural that Within this 4 criteria (Buyer No, between date, Particular type, particular quality) if any is blank , its cover all records for particular that heading .
I already attached screen shot of requirement & related data file.
Hope you can understand which I described here for just want formula or modification in code.
25.4 KB Views: 6