PDA

View Full Version : VBA to auto filter based on 4 criterias



Vassen
07-19-2016, 03:49 AM
Hi Masters,
In attached excel file ,A1 to D1 are the 4 criterias on which the advancefilter will be based on to filter datas in A4:H12.

B1 and C1 = autofilter between dates (Start - end). Job in A1 = either job No1 , 2,3 etc in data columns C4:C,E4:E,F4:F,G4:G.
Status in A4 is either Status 1,2 in data columns D4:D, H4:H
I need a VBA to filter datas with respect to these criterias. If Job 1 is selected, hide data columns for other job number.
Many thanks for your help
Vassen

snb
07-19-2016, 05:19 AM
crossposted:
http://www.excelguru.ca/forums/showthread.php?6397-VBA-to-autofilter-between-dates-in-one-column-based-on-text-value-in-another-column

p45cal
07-20-2016, 05:32 AM
actually the cross post is to:
http://www.excelguru.ca/forums/showthread.php?6399-VBA-for-advance-filter-based-on-4-criterias