Help Please

N

noprobs

New Member
Joined
Mar 28, 2012
Messages
1
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
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

drom
  • Question
pivot table SORT in data source order
Replies
1
Views
495
Misca
M
Livin404
  • Solved
Removing a blank label from Pivot Table.
Replies
5
Views
260
Alex Blakenburg
A
drom
  • Question
SUMPRODUCT to count dependent validation list column with wrong items
Replies
1
Views
152
drom
drom
Rainbow_P
  • Solved
Pivot table's Filters, to deselect items when "Not all items showing"
Replies
7
Views
167
RoryA
RoryA
W
  • Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
191
Anthony47
A

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,399
Latest member
alchavar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top