filtering data if have X value, if not then filter with Y

[extremis]

Hi,

i have the following code

Please Login or Register  to view this content.

What I want is, by clicking on the CartCType button, the macro will check in columns A if it contain 10*...if it does, then filter it with only this criteria 10_C*

if it does contain 20, then filter if with 20_C*

Any help??

[Solus Rankin]

Please Login or Register  to view this content.

you're filtering the whole column? It will only filter by the last value found. Would you like to exit the sub once the first value is found?

[extremis]

Well..i am filtering from A2 to D2 to the bottom..but as the first value is found, it should solve the problem as before i have a macro that will select let say, all the 10...or all the 20...

so, it look a bit like that on my excel sheet

10_C03
10_C05
etc...etc..
10_R01

Also, I tried the macro...it said name argument not found and it highlight in yellow the

Please Login or Register  to view this content.

[extremis]

Sample.xlsmany clue why?....here a sample of the data..see the files!

[extremis]

help lol..

I cant seem to make it work

[Solus Rankin]

You don't have a with statement on your autofilter. It needs to be .cells.autofilter...

Please Login or Register  to view this content.

[AB33]

I do not know what is the purpose of the code.
Why do you need an if statement and a loop? And after a filter is found, what is the purpose- loop in to next row? What happens to the filtered data then?

[Solus Rankin]

Thats why I asked if you need to exit sub. Its just going to filter it again when it gets to the next line. What you'll end up is column A filtered by the last value found in the loop.

[extremis]

has you can see with the file i attached. What I want is..when I will click on 10, it will filter all the 10..then..when i click on C..it will filter all the C on the already filtered list....which mean, all the 10_C*
then at last, when I will click 1, it will filter the already filtered 10 and C and will only filter the 01...which will have for result 10_C_01

another example: If i click on the 20, it will select all the 20...then, if i click on the R...it will filter all the R that are in the 20..so it will look like 20_R*...then, if i want to see all the number 10...it will filter The 20_R_10..

Button click order are selection of the group 10-90 (green button)
Then selection of the Type (mixed, R, Other, MP, C, etc)(Orange button)
and selection of the number 1-96 (Blue button)

I tried to build a macro and make it work..but i got stuck at the second "filtration"

[extremis]

i am sorry..i am learning VBA by myself...and i am not a pro..am at the point where i can take code, play with it, modify it and make it work..but sometime it look a bit messy

[extremis]

I also had this one...but it doesnt work -_-....

Please Login or Register  to view this content.

[extremis]

so what do you think guys?

[extremis]

Xero, I was able to make it work..i am sorry, I had a hard time understand what you said, it seem there was a part missing..here is the code:

Please Login or Register  to view this content.

now for your asnwer, there is no need to be a loop since it<s the first column that is filter..damn i am dumb...THANKS for your helps

[Solus Rankin]

Glad you got it figured out.

[extremis]

i added to your rep guys!