|re: it is copying each row 4 times into the invoice|
That's doesn't happen to me, but obviously I can only set up my workbook based on the description you've provided. There must be something different in your workbook that causes that. I've sent you a email address via PM. If you want to send me a copy of the workbook, I'll take a look at it, but I can't let this turn into a major project.
re: when we delete out what we just entered it does not get deleted form the invoice
Maybe that's because you never asked for that.
Once I see the workbook, I can see if that's possible. I need to know something first. Are you asking to start with a fresh invoice each time (fairly easy) or are you asking to just delete those items that you zero out, leaving the others on the invoice? (That's much harder)
re: I only want to email the customer the Invoice
Here's just one of many hits.