shivam
12-12-2016, 10:30 PM
sir
i am choose customer name in B6 column the customer invoice detail was show on the A12 to G12 columns in payments sheet,all invoice detail pickup from the purchase accounts sheets In payments sheet add payment no in b4 column, b5 coumn choose bank name,b6 columns choose customer name, b7 columns show cutomer invoice no, b8 columns show payment type, b9 columns add cheque no. b10 columns choose status, than click on the add payment button the payment was add on the payment register sheet in this workbook
in payment sheet on show unpaid invoice no only, please send the add payment button vba code sir
thanking you
i am choose customer name in B6 column the customer invoice detail was show on the A12 to G12 columns in payments sheet,all invoice detail pickup from the purchase accounts sheets In payments sheet add payment no in b4 column, b5 coumn choose bank name,b6 columns choose customer name, b7 columns show cutomer invoice no, b8 columns show payment type, b9 columns add cheque no. b10 columns choose status, than click on the add payment button the payment was add on the payment register sheet in this workbook
in payment sheet on show unpaid invoice no only, please send the add payment button vba code sir
thanking you