A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Validation On A Cells With Data From A Different Spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2008, 08:25 AM posted to microsoft.public.excel.misc
Nat Govender
external usenet poster
 
Posts: 1
Default Data Validation On A Cells With Data From A Different Spreadsheet

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
  #2  
Old November 13th, 2008, 09:33 AM posted to microsoft.public.excel.misc
Bob Phillips[_2_]
external usenet poster
 
Posts: 1,562
Default Data Validation On A Cells With Data From A Different Spreadsheet

You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the name
rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in message
...
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



  #3  
Old November 13th, 2008, 10:16 AM posted to microsoft.public.excel.misc
Joerg Mochikun
external usenet poster
 
Posts: 94
Default Data Validation On A Cells With Data From A Different Spreadsheet

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

"Bob Phillips" wrote in message
...
You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the
name rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in message
...
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





  #4  
Old November 13th, 2008, 10:35 AM posted to microsoft.public.excel.misc
Nat Govender[_2_]
external usenet poster
 
Posts: 2
Default Data Validation On A Cells With Data From A Different Spreadsh

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

"Joerg Mochikun" wrote:

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

"Bob Phillips" wrote in message
...
You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the
name rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in message
...
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






  #5  
Old November 13th, 2008, 10:46 AM posted to microsoft.public.excel.misc
Joerg Mochikun
external usenet poster
 
Posts: 94
Default Data Validation On A Cells With Data From A Different Spreadsh

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

"Nat Govender" wrote in message
news
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

"Joerg Mochikun" wrote:

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

"Bob Phillips" wrote in message
...
You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the
name rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in
message
...
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







  #6  
Old December 9th, 2008, 06:55 AM posted to microsoft.public.excel.misc
Nat Govender[_2_]
external usenet poster
 
Posts: 2
Default Data Validation On A Cells With Data From A Different Spreadsh

Hi Joerg,

Sorry, I did mean workbook.



"Joerg Mochikun" wrote:

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

"Nat Govender" wrote in message
news
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

"Joerg Mochikun" wrote:

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

"Bob Phillips" wrote in message
...
You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the
name rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in
message
...
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








  #7  
Old December 9th, 2008, 06:23 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Data Validation On A Cells With Data From A Different Spreadsh

Debra Dalgleish has the how-to for using data from another workBOOK for DV.

http://www.contextures.on.ca/xlDataVal05.html

Note the source book must be open.


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 21:55:01 -0800, Nat Govender
wrote:

Hi Joerg,

Sorry, I did mean workbook.



"Joerg Mochikun" wrote:

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

"Nat Govender" wrote in message
news
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

"Joerg Mochikun" wrote:

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

"Bob Phillips" wrote in message
...
You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the
name rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" Nat wrote in
message
...
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









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.