I am working on a spreadsheet that has 3 pages.

Page 1 obtains data from Sheet 2

Sheet 2 contains data for use on Sheet 1

I have validation set on sheet 2 that limits things to SS#, # of digits allowed, etc.

On sheet 1 I have limited various columns to allowing data only from specific Lists (columns on Sheet 2.)

All was working well. Then, all of a sudden, I can't enter data into sheet 1. It tells me: The value you entered is not from the required list. Everything works fine without validation. I have tried removing all validation and reestablishing it. I can't understand why this is happening. Any insight would be appreciated.

Jan