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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|