Data Validation On A Cells With Data From A Different Spreadsheet

N

Nat Govender

Hi All,

I know that in Excel it says that you cannot reference a diffetent worksheet
when it comes to data validation, however is there any macro that I could use
or is there a formular or is there any other way ?



Your help would be greatly appreaciated.



Thanks in advance
Nat Govender
 
B

Bob Phillips

You can reference another sheet!

Just add a name to that sheet range, Insert>Name>Define..., and use the name
rather than the range directly.
 
J

Joerg Mochikun

One caveat: In Data|validation|settings you have to precede the list source
with "=", so if your range name is "data'" you have to input "=data"
(without quotes)

Joerg
 
N

Nat Govender

Hi,

I have tried that but it does not work.

I want to generate a Validation from a totally different speadsheet.

Thanks in advance
Nat Govender
 
J

Joerg Mochikun

Well, I tested it and it works ("data" was a range on Sheet2, the drop-down
was on Sheet1). I hope that with " totally different speadsheet" you don't
mean workbook...
Joerg
 
N

Nat Govender

Hi Joerg,

Sorry, I did mean workbook.



Joerg Mochikun said:
Well, I tested it and it works ("data" was a range on Sheet2, the drop-down
was on Sheet1). I hope that with " totally different speadsheet" you don't
mean workbook...
Joerg
Click to expand...
 
Top