Validation

Giganews Newsgroups
Subject: Validation
Posted by:  Dick (bobdel…@yahoo.com)
Date: Thu, 20 Jan 2011

Sheet1 has a list of part numbers in Column A.
On Sheet2 column A I'd like for when the user types in a part number
and it does not match part number from Sheet1, an error message shows
invalid part number and prevents the user from entering that part
number.
Thanks so much for any help!
Excel 2003

Replies