Validations in Excel

[ColmR]

Hi,

How can I use a menu on more than one sheet using the List function in Validation by having the data for that list on one sheet only.

I have a number of sheets using the same list function. However when I need to change any characteristics of that list I must change it on each sheet independantly. Is there any way of changing these once by highlighting all the sheets used.

Thanks you,
ColmR

 

[SkipVought]

ColmR,

Give you list a Range Name using the Name Box or Insert/Name/Define.

Use that name in your Validation List
[tt]
=MyList
[/tt]


Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[AnotherHiggins]

Check out Skip's FAQ on creating Dynamic Ranges:
faq68-1331

You can refer to the name of the dynamic range in the source box of the Validation wizard. Then any changes you make to the source list, including additions/subtractions, will be represented in all validated cells!

 

[xlbo]

Basically, the only reason you can't put a range on a different sheet for the list is because of the bang (!) in the sheet name - same applies for advanced filter - by creating a named range, the ! disappears and you can happily reference anywhere you want

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[SkipVought]

Bidda [red]![/red] Bidda BOOM

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[xlbo]

practising the drums again Skip ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question