...
3. With the Excel file opened, click on Data → Filter → and select the category of supplies with mark up you need to update.
In this example, we are selecting the category "backflow."
4. Copy the data to a new Excel file and name the worksheet "Supplies".
...