I have an Excel sheet that I have set up so it will filter by the vendor.
I'll need to send this information by the specific vendor per their request.
Is there a way if I select the vendor from the filter that it can export just
that vendors data to a new sheet so that none of the other vendor information
can be viewed? Then I can just send that new workbook to the vendor.