Easiest way is to filter the data using Autofilter to hide all the rows except
those containing the value in column 10 (J) you want to see. You can do this
without VBA, or you can create a macro  by recording yourself applying the
Autofilter and selecting the desired value.