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?

On Apr 19, 10:25 am, wrote:
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?

So, if I understand correctly, the problem is that the copy of the
graph in the new worksheet keeps changing based on which centre is
selected in the original worksheet. Is that right?
If so, one thing you could do is copy the graph as a picture. Select
the graph, and open the edit menu while holding the shift key. There
should be an option there to "Copy Picture...". You can then paste the
chart as a regular picture, which will not change.

Good luck,
David