Filter and no filter VBA- Auto Populate

[thanhthinh1234]

Hello,

So let's say I have 5 columns: ID, Class, Location, Segment and the last one Response(Yes/No)

I already wrote a code that if I don't filter anything, whatever value I choose will apply to only one row. If I filtered, the values will be the same and populated same within the filtered groups. My question is, I want to make ID as an exception. So for example, if I filter ID just by itself, I want the result as of no filter at all (NO propagation, which ever value I choose will apply only to one row), but if I filter ID + Class/Location/Segment, it will be considered as filtered groups and of course my current VBA code will take care of that.

Thanks so much for helping

I've attached my code which is for the specific situation and also the excel workbook as an example. Appreciate all the help. Thanks so much!

Best,

Please Login or Register  to view this content.

[AlphaFrog]

Your code doesn't work with the example workbook.

Here is a function that will test if Only the ID column (the 1st column in the filter range) is filtered. I'll leave it to you to integrate it with your existing code.

Please Login or Register  to view this content.

[thanhthinh1234]

Awesome that works perfectly. Thank you!!!!

[AlphaFrog]

You're welcome. Thanks for the feedback.