EXCEl is not for generating invoices. Get quickbooks for that! If a free solution is what you are looking for, check out:
BTW, you can do it, but it is klugy! Beside, are you planning on ever referring back to the invoice, as my EXCEL solution won't save each one!
It's kind of fun to do the impossible! -Walter Elias Disney