Forum

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

Hi Formula worked fine until Week number changes to start with 2, then result is wrong? I can't work out what has gone wrong< any help greatl...

Thanks Mynda