On 14 Nov, 18:46, "Filips Benoit" wrote:
Hey,

My sheet has 1000 row with payments of clients.
In row 1 i have autofilter to select 1 client
In row 1001 i have the subtotal-function showing the total for this client.

I should print and email the clients data
The print only show his data, no problem.
But the email shows his data but contains all data !!!

How can i save only the clients data to a new workbook before emailing it to
the client ??

Thanks,

Filip

Try pasting row 1001 (sub total) into a new sheet when you do paste
make sure is a "Paste Special" on the edit and link it to the main
sheet.

Johnnyboy