hello all,
i have vba code which is updating 10 pivot tables with the value i selected from drop down list manually.. so if i select team='abc' from drop down list it will select in all 10 pivot tables filter field to team='abc' .. so the problem is if the team='abc' is not present in some pivot tables out of that 10 say 2 tables dont have the team called 'abc' so i want them to update as default team 'xxxx' which i want to hard code in vba as i know the team 'xxxx' is present in all 10 pivot tables ...

please let me know if you need more detail.. this is my first post in forums so please apologise for short story

Thanks in advance