Originally Posted by
p45cal
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.