I'm ok with vBA macro's but sometimes have trouble figureing out to get one started, though I can usually alter a preexisting macro to do what i want it to do.
I need a VBA Macro that (when run) will Copy a worksheet in my workbook, then transfer data from a list into said worksheet and then print it.
Worksheet 1 (Worksheet containing a list of customer information such as name, address, phone number, charges, ect)
Worksheet 2 (A blank invoice)
Worksheet 1 has 10 customers (though this number can change) listed with their information. I'd like to be able to click a button and have it copy an invoice however many times it needs to to make an invoice for every customer, and then copy said customer information over to it's respective invoice, and then prints all the invoices once done.
I'm not sure if it's possible.