chamdan
05-05-2012, 10:09 PM
Hi,
I :banghead: trying to resolve this issue and could not.
I want to filter an excel worksheet with the following criteria.
I want based on certain selection that the filter will extract data that have in column AC starting from AC4 to AC2500 the following codes:
Filter only the ones that have a code as: 002|* and all the sub-elements such as 002| can have 100's of sublevel that looks like 002|010 or 002|020 and so on then 004|* or codes that have 006|* and maybe 009|*
Has anyone had any problem with the filter where the filter gets you no data extracted when the criteria eceeds 2 selections. Because with 2 selections I have no problem but If I add one more then nothing is extracted.????? I have used arrays as criteria and did not work an example is below:
Range("AC3" & ":" & "AE" & LastRow).AutoFilter _
Field:=1, Criteria1:=arrCriteria, Operator:=xlFilterValues
where Criteria is an Array of the selected criteria.
Your help is needed.
Thanks in advance.
Chuck
I :banghead: trying to resolve this issue and could not.
I want to filter an excel worksheet with the following criteria.
I want based on certain selection that the filter will extract data that have in column AC starting from AC4 to AC2500 the following codes:
Filter only the ones that have a code as: 002|* and all the sub-elements such as 002| can have 100's of sublevel that looks like 002|010 or 002|020 and so on then 004|* or codes that have 006|* and maybe 009|*
Has anyone had any problem with the filter where the filter gets you no data extracted when the criteria eceeds 2 selections. Because with 2 selections I have no problem but If I add one more then nothing is extracted.????? I have used arrays as criteria and did not work an example is below:
Range("AC3" & ":" & "AE" & LastRow).AutoFilter _
Field:=1, Criteria1:=arrCriteria, Operator:=xlFilterValues
where Criteria is an Array of the selected criteria.
Your help is needed.
Thanks in advance.
Chuck