Selecting Items from drop down list
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? |
Selecting Items from drop down list
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 |
All times are GMT +1. The time now is 02:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com