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
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