Validating Cells
When validating cells is it possible to pick the list critria from a
different sheet? Regards The Rook |
Validating Cells
Yep,
If you insert a Name (Insert-Name-Define) into the sheet on which you have the validated cell, and link that name to the range on the external source containing the list, then link the validation list source to the Name you've just defined, you can do this. If you have a look on the Excel Help Menu for "specify the valid entries for cells" there's a bit more in-depth info about how to do this if you've not linked names to external sources before. HTH DS "TheRook" wrote: When validating cells is it possible to pick the list critria from a different sheet? Regards The Rook |
Validating Cells
Yes it is. Give the list a name (InsertNameDefine...), and then use the
name in the data validation. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TheRook" wrote in message ... When validating cells is it possible to pick the list critria from a different sheet? Regards The Rook |
All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com