I have a worksheet that has a drop down list on it. Within the drop
down list, there are 52 different center names. When a center name is
clicked, the corresponding data for that center is displayed. There
are 6 graphs, and the source data for each graph is located directly
to the right of the graph. The problem is, whenever I copy a graph
from a particular center onto a new worksheet, the information will
change on the new worksheet to what center is currently being
displayed on the other. Is there a macro that automatically brings up
the sheet, and selects a center?