Hi, I have data in sheet 2 in coloumn A to C like (please see below)
A B C ------------coloumns
1 GG ST1
2 BB ST2
3 CC ST3
4 DD ST4
5 EE ST5
i am looking for macro that if in sheet 1 from coloumn A to C I put
same data then it do nothing but when I put different data then it
should give message that its not in sheet 2 list. Please note that the
data which i'll put in sheet 1 should be in same sequence like if data
in sheet 2 is
A B C
1 GG ST1
then if i put in sheet 1
A B C
1 BB ST1
then it should give message that its not in sheet 2 list as data has
to be in same sequence like
1 GG ST1 instead of 1 BB ST1
Please if anybody can help. Thanks