Hi Everyone,

I've been looking everywhere but can't find a solution to the problem I'm facing.
I have a invoice template that has basic information like "invoice number", "date", "customer", "Part#" etc..
I can fill this out and click a "add" (VBA) button that automatically adds all the information entered into a spreadsheet.
The problem is that I can only do this for 1 part at a time.
Is it possible to have multiple parts for the same invoice so it basically adds multiple lines to the spreadsheet with the same invoice number but different part #'s.
For example if I have two part numbers for an invoice, the invoice number, date etc.. will be copied twice but the part #, description etc.. will be different.
I hope I'm making sense. Really need help on this one.
Thanks