Email only filtered data in Excel

[stefani13]

I have filters on several columns in a spreadsheet (Excel 2002). I know I
can do File-Send To-Mail Recipient and email a "picture" of the filtered data
to someone. However, if I use File-Send To-Mail Recipient (as Attachment),
the recipient can remove the filters and view all of the data. Is there a
way to send only the filtered data to the recipient and they cannot expand
the columns to show everything? I'm banging my head on my desk!

Thanks,
Stephanie

 

[Susan Ramlet]

Hi, stefani13,

Without copying the filtered data to another sheet, I don't believe there's
a way within Excel's Autofilter. You can use the Advanced Filter option to
copy the results to another location.

There's also a free filter that some MVPs wrote that allows you to filter to
a new sheet: EasyFilter. I've used it, and it's quite nice:

http://www.rondebruin.nl/easyfilter.htm

 

[Ron de Bruin]

Hi Susan and Stephanie

EasyFilter is a good suggestion Susan but I answer in the Excel group with this

I have example code on my site to send only the visible cells in the selection
http://www.rondebruin.nl/sendmail.htm

But you can also use my Add-in to do it (only attachment)
http://www.rondebruin.nl/mail/add-in.htm

Stephanie, if you want a code example that also protect the sheet post back.
But I must know your mail program