i have sale item userform
when i fill the sale form it creates automatic new sheet of party name but problem is that repeat entry many time why ? plz solve this problem some syntax error i think .

image 2 sheet why created i an need this sheet this sheet is not created.

help me

thanks in advace