I recorded a macro in excell that contains 15 col and 500 rows, in col10 I only want to display a certain value (i.e W2) and delete or hidethe rest of the rows. Any help or the actual macro to do this will beappreciated.
Easiest way is to filter the data using Autofilter to hide all the rows exceptthose containing the value in column 10 (J) you want to see. You can do thiswithout VBA, or you can create a macro by recording yourself applying theAutofilter and selecting the desired value.