Hi all,


I'm currently trying to copy figures from one pivot to another sheet. Say I filter staff sales by month, if there is no value for a column ( say, no sales for John this month) , the pivot will "shrink" and I would have to manually adjust my range in the other sheet.

Is there a better way to do this?

Need help. Thanks!