Hey All,

I have an Invoice on a sheet, which contains few data etc ( Name, Unit, Payment Details, Parking, Rent, Parking)
I want to copy all this data from another sheet (Main Sheet).
This main sheet contains few rows which contain same data, but i want to only copy one rows at a time.
And i want to add a print function to the invoice as well with auto-update invoice number.

Is it possible to put all this function in one command button?

The payment Details have a combo box which contains ( 3 options), I want the details to be copied according to the option selected.

test123.xlsm
I have attached the workbook for assistance.

Thanks and regards
Leo.