Hi All,

I need to force user inputs when inserting data on a row.

Example:

I have 3000 rows of data that needs to be Entered by a user into the worksheet

Transaction 1: A1, B1, C1, D1, E1
Transaction 2: A2, B2, C, D2, E2
etc....

How do I force the user to enter the data of transaction 1 in the order I
like ??
Ex. A1 first, then B1, then C1, then D1, then E1
Otherwise ERROR

OR

How do I force the user to enter CELL B1, before able to enter CELL D1 or E1
??


Thanks in advance.