Copying filtered data using advance filter to another sheet

B

bandula

Hi All

Can anybody tell me how to copy filtered data usiing
advance filter to another worksheet (not the one
containing list)

Thanks Bandula
 
P

Peo Sjoblom

Hi,

you could start from the other sheet and then
copy the list when you filter or you could select the
filtered list. Press F5, click Special and select visible
cells, copy and paste..

Regards,

Peo Sjoblom
 
Top