can I export just the autofiltered data into own sheet?
 

Need help extracting data from worksheet. Have figured out how to get in 1
area with the filter, but dont know how to extract it all at once

Hi

once you have filtered
click on the first cell and press control & shift & end
this should highlight the data that you have displayed
then choose
edit / goto / special
click visible cells only
then choose edit / copy
go to where you want to copy the data to
and choose edit / paste

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"kst82276" wrote in message
...
Need help extracting data from worksheet. Have figured out how to get in
1
area with the filter, but dont know how to extract it all at once