Code to trigger drop down-select event

[Guest]

I have a workbook that contains three worksheets:
a data table
a pivot table report of the data table (with the "Organization" field
located in the pivot table's Page field)
a switchboard with a drop-down box that contains the organizations listed in
the data table and pivot table

I need some code that selects the organization in the Organization page
field of the pivot table that corresponds to the organization selected from
the drop down. So, if one selects, say, "New York" from the drop-down box,
"New York" is selected from the pivot table Page field ("Organization") and
the pivot table refreshes to show New York-only data.

Thanks,
EU

 

[Tom Ogilvy]

Turn on the macro recorder and change the value in the pagefield of the
pivot table.

Now turn off the macro recorder. Now generalize the code so the hard coded
value uses a variable that is populated with the value of the dropdown.