Hi friends,
I wanna create a checker macro where in a row with Column names G1 M1, G2 M1 & G3 M1 (1st column of each group) should not contain same names. same like that need for M2s and M3s as well.
Please find attached the excel file for more clarity. have marked red in the rows where names are appearing twice or more in the respective M(s) of each group.
The macro should not allow a user to enter duplicate values in the above mentioned manner.
Say for instance a person named Sam , can enter his name in G1 M1, G2 M2/G2 M3 , but should not enter in G1 M1 , G2 M1/G3 M1
kindly help
thanks
Bookmarks