Copying filtered data using advance filter to another sheet

  • Thread starter Thread starter bandula
  • Start date Start date
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
 
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
 
Back
Top