Hi,

Does anyone know if pivot tables can be based on dynamic ranges (defined
with OFFEST/COUNTA)? as I've tried but can't seem to get it to work.

Many thanks,

Jason