Dynamic range across sheets and Advanced filter

  • Thread starter Thread starter Angus
  • Start date Start date
A

Angus

Hi,

I have two sheets of data with same structure (data more than one sheet can
carry), and want to use advanced filter to copy data to a new location. How
to make advanced filter List Range includes these sheets?

Thanks.

Regards,

Angus
 
Hi Angus

You can't make the range for AF span 2 worksheets.
You will need to carry out your extraction form each sheet separately, using
the same criteria, then combine the 2 extracts to another sheet.
 
Back
Top