Pull Data from Master sheet to another sheet
I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor list. Does anyone have suggestions on how to go about doing this?
I appreciate any assistance.