Quote Originally Posted by p45cal View Post
Your second file is considerably different from your first, especially regarding there being multiple skills and experience in single cells.
Hiding/unhiding rows with code doesn't work well with autofilters; to get unambiguous results it needs to be autofilter only, or something else without autofilter.


The main problem lies with the unconventional data layout. To cater easily for many aspects requires a radical change of data layout. Having said that, attached has a bespoke solution for your new scenario.

need your help please