Hello,

I have a worksheet with an autofilter that shows the data I am interested
in. Is it possible to run a macro to delete everything else on the
worksheet so that I could remove the autofilter and be left with only the
filtered data. The reason being that the info is going to a 3rd party and
should not get all the data on the worksheet

Thanks

I don't think you need a macro to do that, just highlight the filtered range
and Copy Paste it to another worksheet or a worksheet in another workbook
and send that,
Regards,
Alan.
"Sierras" wrote in message
...

Hello,

I have a worksheet with an autofilter that shows the data I am interested
in. Is it possible to run a macro to delete everything else on the
worksheet so that I could remove the autofilter and be left with only the
filtered data. The reason being that the info is going to a 3rd party and
should not get all the data on the worksheet

Thanks

Instead of using an AutoFilter, you could use an Advanced Filter to
extract the data to a different worksheet or workbook. There are
instructions in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

Sierras wrote:

I have a worksheet with an autofilter that shows the data I am
interested in. Is it possible to run a macro to delete everything else
on the worksheet so that I could remove the autofilter and be left with
only the filtered data. The reason being that the info is going to a
3rd party and should not get all the data on the worksheet


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html