How to export certain rows into a new sheet.

I have a spreadsheet with numerous values and information, including component parts and a component owner.

I am performing an audit of this list and need to email each of the owners with a sheet with just their components, there are about 80 owners, is there a way I can quickly export all the information of an owners components into a new sheet without ctrl c, ctrl v?

Thank you,

Sammy.

See Excel help of advanced filter …