Forum

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

Hi Velouria, Yes, formula works perfectly, I forgot INDEX as rarely use it. Thank you so much for your help. Regards Paul

Thanks Velouria Works perfectly Regards Paul