hi, sintek i have found error type mismatch in the code if i fill data not match in what contain the sheet in this line
HTML Code: 
if there is way when not match data then show message box "not match" and exit sub " i appreciate that