PDA

View Full Version : Sleeper: Data entry validations



bsync
03-07-2010, 08:40 AM
Friends I need your help to sort these things out..Pls help me

sample data:

A
C A1
C1 A2
C2 A3
C3 A4
C4

C5 My queries:

1.Warning should be displayed saying please fill Coulmn A5 as well
user should not be able to work unless he has filled in A5

If he has entered a value in c6 the he needto fill in A6 as well
and so on


2.The Value entered in A5 should be in this format REM-XXX
xxx are numerics

this could be achieved using regex I believe
most importantly I am sorting the coulmn once data is saved so presence of "-" and absence of "-" makes a huge difference

3. Value entered in coulmn A should not be a duplicate
Before saving the value I need to check if Column A already contains the value

hope I am clear

pls help me with the vba script to achieve this