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
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