Deleting filtered out data from a worksheet
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
|