| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation rule
Hi How do i slove this question? In the order form worsheet, all customer
orders should be based on product in the product_List table. in the range B2:B20, add a data validation check to ensure that item IDscome from the list values in the Iem_IDs range note: the order form is a sheet on its own and the product_List tabl is as well on a seperate sheet thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation rule
Hi,
Here are the steps for creating a data validation list: 1. Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. A. Lists can be manually entered: 1,2,Monday,Tuesday (no quotes are necessary, but the entries should be separated by commas.) B. Lists can get their data from ranges: =$A$1:$A$10 If you use a range reference, as above, the range must be on the same sheet as the data validation. If you want to refer to a range on another sheet that range must be named and you references it as =MyList You can name a range by selecting it and typing the name into the Name Box (top left side of the Formula Bar) and pressing Enter or you can use the Insert, Name, Define command. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Amin" wrote: Hi How do i slove this question? In the order form worsheet, all customer orders should be based on product in the product_List table. in the range B2:B20, add a data validation check to ensure that item IDscome from the list values in the Iem_IDs range note: the order form is a sheet on its own and the product_List tabl is as well on a seperate sheet thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation rule
Hi ShaneDevenshire, i just tried your sugestion and this is the results
below any thoughts on it? cheers. am suppose to restrict the entries to the IDs in within the Product_Lis column Item ID Item Name =Product_List =Product_List =Product_List =Product_List =Product_List =Product_List "ShaneDevenshire" wrote: Hi, Here are the steps for creating a data validation list: 1. Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. A. Lists can be manually entered: 1,2,Monday,Tuesday (no quotes are necessary, but the entries should be separated by commas.) B. Lists can get their data from ranges: =$A$1:$A$10 If you use a range reference, as above, the range must be on the same sheet as the data validation. If you want to refer to a range on another sheet that range must be named and you references it as =MyList You can name a range by selecting it and typing the name into the Name Box (top left side of the Formula Bar) and pressing Enter or you can use the Insert, Name, Define command. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Amin" wrote: Hi How do i slove this question? In the order form worsheet, all customer orders should be based on product in the product_List table. in the range B2:B20, add a data validation check to ensure that item IDscome from the list values in the Iem_IDs range note: the order form is a sheet on its own and the product_List tabl is as well on a seperate sheet thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation rule
Hi,
You're not following some step, but I don't know which one. From the original post: "If you want to refer to a range on another sheet that range must be named and you references it as =MyList" or in your case =Product_List. This doesn't go into the sheet, it goes into Data, Validation, List, Source =Product_List How: "Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. " -- Thanks, Shane Devenshire "Amin" wrote: Hi ShaneDevenshire, i just tried your sugestion and this is the results below any thoughts on it? cheers. am suppose to restrict the entries to the IDs in within the Product_Lis column Item ID Item Name =Product_List =Product_List =Product_List =Product_List =Product_List =Product_List "ShaneDevenshire" wrote: Hi, Here are the steps for creating a data validation list: 1. Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. A. Lists can be manually entered: 1,2,Monday,Tuesday (no quotes are necessary, but the entries should be separated by commas.) B. Lists can get their data from ranges: =$A$1:$A$10 If you use a range reference, as above, the range must be on the same sheet as the data validation. If you want to refer to a range on another sheet that range must be named and you references it as =MyList You can name a range by selecting it and typing the name into the Name Box (top left side of the Formula Bar) and pressing Enter or you can use the Insert, Name, Define command. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Amin" wrote: Hi How do i slove this question? In the order form worsheet, all customer orders should be based on product in the product_List table. in the range B2:B20, add a data validation check to ensure that item IDscome from the list values in the Iem_IDs range note: the order form is a sheet on its own and the product_List tabl is as well on a seperate sheet thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation rule
Hi Shane i have now got my brains back, your sugestion has worked right
thanks for the support "ShaneDevenshire" wrote: Hi, You're not following some step, but I don't know which one. From the original post: "If you want to refer to a range on another sheet that range must be named and you references it as =MyList" or in your case =Product_List. This doesn't go into the sheet, it goes into Data, Validation, List, Source =Product_List How: "Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. " -- Thanks, Shane Devenshire "Amin" wrote: Hi ShaneDevenshire, i just tried your sugestion and this is the results below any thoughts on it? cheers. am suppose to restrict the entries to the IDs in within the Product_Lis column Item ID Item Name =Product_List =Product_List =Product_List =Product_List =Product_List =Product_List "ShaneDevenshire" wrote: Hi, Here are the steps for creating a data validation list: 1. Select the range 2. Choose Data, Validation 3. From the Allow drop-down and choose List 4. In the Source box enter the list. A. Lists can be manually entered: 1,2,Monday,Tuesday (no quotes are necessary, but the entries should be separated by commas.) B. Lists can get their data from ranges: =$A$1:$A$10 If you use a range reference, as above, the range must be on the same sheet as the data validation. If you want to refer to a range on another sheet that range must be named and you references it as =MyList You can name a range by selecting it and typing the name into the Name Box (top left side of the Formula Bar) and pressing Enter or you can use the Insert, Name, Define command. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Amin" wrote: Hi How do i slove this question? In the order form worsheet, all customer orders should be based on product in the product_List table. in the range B2:B20, add a data validation check to ensure that item IDscome from the list values in the Iem_IDs range note: the order form is a sheet on its own and the product_List tabl is as well on a seperate sheet thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Rule | New Users to Excel | |||
| Validation Rule anomaly | Excel Worksheet Functions | |||
| Identifying formulas using a Validation rule | Excel Worksheet Functions | |||
| Validation rule | Excel Discussion (Misc queries) | |||
| validation rule | Excel Worksheet Functions | |||
Linear Mode
