Hi,
(I have attached an example spreadsheet). I would like to know whether there is any easy way to copy the data from each countries months sheets data eg. 'paid' 'cancelled' 'total' onto the 'retention' sheet. So I would have 'Total' 'Paid' 'Cancelled' from each pivot on each sheets data all filled in on this retention sheet. Is there a formula or a way to copy without going through manually as this would take some time!
Cheers
Bookmarks