Data validation from a different spreadsheet

[Ramy27]

In Excel (XP), I'm trying to create a drop down menu for some cells where the menu should be filled by a list of data from a different spreadsheet. Obviously I can't use data validation, because it doesn't won't allow list from other spreadsheets. any idea?

---------------------------------
Your help is much appreciated, R.
---------------------------------

 

[SkipVought]

Ramanesh,

Name the range on the other sheet. Then you can use data/validation using the range name.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[xlbo]

To explain, it is the same bug as that which affects the Advanced Filter functionality. The code that runs in the background doesn't like the bang (!) that comes after a sheet name in standard syntax. When you name a range, you do not have to specify a sheet and there is therefore no ! to resolve and everything works !!

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question