LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Rule aubrey New Users to Excel 0 October 28th 08 07:12 PM
Validation Rule anomaly Bob Excel Worksheet Functions 6 March 8th 07 08:36 PM
Identifying formulas using a Validation rule Bob Excel Worksheet Functions 8 November 22nd 06 09:34 PM
Validation rule nick Excel Discussion (Misc queries) 4 March 6th 06 04:57 PM
validation rule andrewm Excel Worksheet Functions 7 June 23rd 05 06:45 AM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"