PDA

View Full Version : Restrict Data in Cells



jerryhouston
02-04-2007, 06:27 PM
I have two columns of data, one is category and the other is equipment number. I have a data input sheet (Sheet1) and would like to validate the data on the tab labeled supplier , category is in column E and Equipment number is in column F.

Thanks.

geekgirlau
02-04-2007, 11:48 PM
Hi Jerry,

Would you be able to post a small sample of what you're after? It's much easier than trying to visualise the structure of your workbook.

Bob Phillips
02-05-2007, 02:31 AM
Sounds like you want Data Validation. See http://www.contextures.com/xlDataVal01.html