Hi, every time when user use the userform, data is pasted to few of columns and so far I have managed to paste the values in worksheet 1. Following are the column headers in sheet1.

Date of Entry Item Code Product Description Serial Number Qty

How do I copy the values of Date of Entry, item code, product description and serial number to another work sheet named Serial No?

Secondly, values of the serial number in a combo box depends on the selection of the product selected. The values of the serial number is kept in a worksheet named Serial No. Values of the serial number shown in the userform is coded in a way by referring Serial No worksheet which has multiple rows of records from column A to D.

When product is consumed, the entire row of that product serial number should be deleted in the Serial No worksheet which is column A to D so that user should not be able to select that serial number in the userform as same product type may have different serial number.

May I know how do I achieve that?