Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Create two Data validation lists that are linked(Both change toget

Hi,

I would like to create two or more validation lists of the same range of
data. Currently, I have a number of graphs on different worksheets that can
be updated by choosing from a drop down list (data validation list).
Basically, that list is referenced in a lookup function which gathers
information into a range that then updates the graphs. Right now, I have to
click back and forth between many sheets in order to to change the drop down
menu. It would be ideal that if each worksheet with a graph had the exact
same drop down menu that when updated, updates each of the other drop down
menus accordingly. So if I change the list in worksheet 1, all worksheets
lists update. If I change the list in worksheet 2, all of the worksheets
lists update...and so on.

I have the same problem with just single cells. I need to have two or more
cells act exactly the same. For example, I have cells A1 and B1. If I change
A1 to yellow, B1 should change to yellow. Then, if I change B1 to Red, A1
should change to red. As you can see, I need to be able to change both cells
(for convenience to the user) as if they were both linked to an underlying
cell except without having to find and click on the underlying cell to change
A1 and B1, I want to just click on either A1 and B1 to change it. Does this
make sense?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default Create two Data validation lists that are linked(Both change toget

Regarding the Data Validation cells. Create one list somewhere. Name that
range something, say, MyList. Setup every Data Validation cell to List and
type "=MyList", without the quotes, in the "Source" line. When you want to
change the list, go to the list. Change it. If the range is changed
because you added or deleted an item, name the new range "MyList". Done.
The other thing. I know of no way to link cell formats. Perhaps you can
link the situation that caused the user to want to change the color of some
cell. Then Conditional Formatting or VBA can be used to change the color of
both cells. HTH Otto

"VChaseS" wrote in message
...
Hi,

I would like to create two or more validation lists of the same range of
data. Currently, I have a number of graphs on different worksheets that
can
be updated by choosing from a drop down list (data validation list).
Basically, that list is referenced in a lookup function which gathers
information into a range that then updates the graphs. Right now, I have
to
click back and forth between many sheets in order to to change the drop
down
menu. It would be ideal that if each worksheet with a graph had the exact
same drop down menu that when updated, updates each of the other drop down
menus accordingly. So if I change the list in worksheet 1, all worksheets
lists update. If I change the list in worksheet 2, all of the worksheets
lists update...and so on.

I have the same problem with just single cells. I need to have two or
more
cells act exactly the same. For example, I have cells A1 and B1. If I
change
A1 to yellow, B1 should change to yellow. Then, if I change B1 to Red, A1
should change to red. As you can see, I need to be able to change both
cells
(for convenience to the user) as if they were both linked to an underlying
cell except without having to find and click on the underlying cell to
change
A1 and B1, I want to just click on either A1 and B1 to change it. Does
this
make sense?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Create two Data validation lists that are linked(Both change toget

On Mon, 25 Jan 2010 08:30:01 -0800, VChaseS
wrote:

Hi,

I would like to create two or more validation lists of the same range of
data. Currently, I have a number of graphs on different worksheets that can
be updated by choosing from a drop down list (data validation list).
Basically, that list is referenced in a lookup function which gathers
information into a range that then updates the graphs. Right now, I have to
click back and forth between many sheets in order to to change the drop down
menu. It would be ideal that if each worksheet with a graph had the exact
same drop down menu that when updated, updates each of the other drop down
menus accordingly. So if I change the list in worksheet 1, all worksheets
lists update. If I change the list in worksheet 2, all of the worksheets
lists update...and so on.

I have the same problem with just single cells. I need to have two or more
cells act exactly the same. For example, I have cells A1 and B1. If I change
A1 to yellow, B1 should change to yellow. Then, if I change B1 to Red, A1
should change to red. As you can see, I need to be able to change both cells
(for convenience to the user) as if they were both linked to an underlying
cell except without having to find and click on the underlying cell to change
A1 and B1, I want to just click on either A1 and B1 to change it. Does this
make sense?




See if the pop up boxes on this perpetual calendar's set-up page works
the way you want. There are hidden columns that have data in them that
the pop up boxes get referred to in the non-hidden area.
Reply
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
Excel -- Data Validation -- Create Dependent Lists Louisa Excel Worksheet Functions 6 October 9th 09 03:27 AM
Linked Lists / Data Validation - Excel 97 Phendrena Excel Worksheet Functions 1 July 7th 08 06:49 PM
How to create Dropdown lists not using Data Validation Catlady Excel Discussion (Misc queries) 3 December 13th 06 06:06 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Data Validation - Create dependent lists Little pete Excel Discussion (Misc queries) 1 May 23rd 05 12:04 PM


All times are GMT +1. The time now is 02:28 PM.

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

About Us

"It's about Microsoft Excel"