Need help frnds...
I have a sheet where there are two cells: C18 and J12
C18 has a numeric value and there are 4 numeric charachters there like 4412,4416, 4417,5437 (these are numeric combinations and the combination will always be of 4 numeric charachters)
J12 contains text
what i want is that macro which checks if from C18 to C4018, if there is any numeric combination which ends with 7 then it checks if the text in cell J12 starts only with AAA or BBB or CC or DD (these will always stay the same), if it does, then it is ok, otherwise it gives a pop up message showing error.
guys plz help me with this.....
thanks heaps
i think if then and loop statement will do here, with message box
Bookmarks