I'm making a list of all the items I own. I want to place all the items in a list on a single sheet. Each Item will have a "category code" attached to it. I would like additional sheets to:
- Look through the master list for a specific category code.
- Then, when it finds a matching code to copy the entire row over to the new sheet.
What command do you use to search the column for a value, and then tell sheets to print the associated row?