Forum

Hi The data for Ibis Swansea on row 70 on the 'Sites & Groups' tab, should be feeding through to the 3 tables on the 'Report' tab, but 'Ibis Sw...

Thank you, Riny, I did not know you could use SUMIFS for this type of query, you never stop learning. Regards Paul

Thank you so much for your help Catalin, Sorted, I would not of thought of that solution, Regards Paul

Hi Catalin Thanks for your reply, the issue I have is that the slicer on the 'Sites' tab shows all 244 sites not just the 30 sites showing in Pivot...

Thanks Mynda I will post a new topic in VBA section Regards Paul

OK Thanks Mynda

Thanks Mynda

forgot attachment, having a bad day GP-Early-Bird-Report-PB-1.xlsm

Sorry, just realized first attachment was password protected.

Thanks Will try and update those formulas as well Regards Paul