Hi experts,

First of all, my level of Vba knowledge is very basic.

This is what I would like to do:

A person completes a form with personal IDs and an Invoice Number associated to it.

It will be about 10 lines, but two or more people can have the same invoice number.

So, for example:


Line Name Total to charge Invoice #
1 Donald Duck $234 INV001
2 Patricio Donald $345 INV002
3 Bilin Bilin Bilin (Tribilin) $45.70 INV001

...

A person will manually enter the date for the Invoice # and in theory I could have between 1 and 10 different invoices.

I will need to:
- Create 1 worksheet for each invoice (please note that the number of invoices and therefore worksheets automatically created might be different each time)
- Name each worksheet according to the name of the invoice
- In each of the Invoice worksheets, create a table and formulas. The table and the formulas will be the same for each invoice worksheet.


Is there anyone able to get me a start point on this please?

Thank heaps