can I export just the autofiltered data into own sheet?

K

kst82276

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
 
J

JulieD

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
 
Top