#1
|
|||
|
|||
Updating dependent Data list display
I have used Data Validation to display a list of variables. I also have a secondary list whose content is based on the value selected in the first list. When I select a different value in List 1, List 2 is updated correctly, however, the cell displaying List 2 continues to display the old value. Is there a way to get the cell displaying the value from list 2 to either update or go blank when list 1 selection is changed?
Thanks |
#2
|
||||
|
||||
Hi AHB,
See the solution I posted at: http://windowssecrets.com/forums/sho...474#post861474 The dependent selection is blanked via the macro code whenever the primary selection is changed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Macropod. The macro works like a charm.
AHB |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link to and display data | Shane.thompson | Excel | 1 | 06-28-2012 06:07 PM |
Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
Auto-updating powerpoint from linked files for 3 weeks of data... Help? | chrisbru | PowerPoint | 1 | 07-08-2010 04:29 AM |
Data Set Display Size - PP 2007 | TonyMan | PowerPoint | 1 | 04-14-2010 05:45 AM |
New entries in Outlook 2007 Contacts List will not display | doveton | Outlook | 0 | 09-03-2009 02:39 AM |