LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting Multiple items from drop down list prem Excel Discussion (Misc queries) 5 December 31st 08 09:58 AM
automatically selecting items in drop down list Tom Mucciolo Excel Discussion (Misc queries) 5 September 2nd 08 04:31 AM
selecting multiple items from drop-down list [email protected] Excel Discussion (Misc queries) 1 October 25th 07 01:24 PM
selecting multiple items in an excel drop down list karen f Excel Discussion (Misc queries) 4 August 13th 07 08:22 AM
Selecting multiple items from a drop down list Jeremy Excel Discussion (Misc queries) 4 December 11th 06 02:53 PM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"