A colleague has Autofiltered a spreadsheet and then wishes to create a Pivot
Table based on the filtered data. He can create the PT fine, but ALL data is
used, not just filtered.
Is there a way around this, or a better solution?

Any assistance gratefully accepted and TIA,
Amanda