Hi All,I have created a multiple row Userform to add multiple values at once. Now i need to restrict the userform to add the data onto the excel sheet if any userform field remains blank and prevent duplicate entry which already exists.

For example please refer below table:-

Date Party Name INvoice NO. Net Amount Tax Gross
1.
2.
3.
4.

And after clicking the "Add Button" on the userform the data should get cleared after adding onto the excel sheet.

Thanks