Using a cell on another worksheet as input for data validation

Hi,

Situation: I have an Excel file with multiple worksheets. Each of these worksheets contain the same rules for data validation in a certain column (G).

Problem: If I want to add an item to the data validation lists I have to edit every single worksheet. I've tried making a seperate worksheet containing data validation items and using that as the source for the data validation rule, but Excel doesn't allow me to switch worksheets while defining the source.

In other words, I want to manage my data validation rules of multiple columns in multiple worksheets in one central location.

I hope this is clear enough. I'm using Excel 2007.

[s]Edited: I'd also like to manage the conditional markup (I'm guessing that's what it's called in the English version) of these columns from a central location.[/s]

Hi,

You can work around this by defining the validation list as a named range, and entering the name of the range in the validation dialogue.

you could have also created a macro i believe =]