I have list of 10 city name in cell A6 to A15, which changes as we select the country in cell A3.
Now I have a pivot table with field "cityName" at Row Labels of pivot. I would like to select this field item as per the value in cell A6 to A15 thru vba. The country with the city list and the pivot table is in the same sheet. Thanks
Now I have a pivot table with field "cityName" at Row Labels of pivot. I would like to select this field item as per the value in cell A6 to A15 thru vba. The country with the city list and the pivot table is in the same sheet. Thanks
