Hi, Need a bit help for now. I am going to make transmittal that has two sheets which includes input(data) and output(transmittal). This will be my transmittal and drawing list monitoring. I am now confused of putting error codes and to be honest I don't have any idea anymore about macros codes in VBA. So, all my inputs will appear on transmittal sheet (whick is the sheet 2) and ready to print for my output. I will also use command button. Please I badly need your help.